Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “soffits” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

158 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
soffits133509(None) 
soffit1237881soffit_
boffins15329072boffins
coffins153110192coffins
comfits14328742comfits
confits122811422confits
haffits1636192haffits
softies103414612softies
softs85019232so_f_ts
toffies133210212toffies
afrits9311903_afrits
baffies153612943baffies
befits114711503_befits
biffies152710853biffies
biffins15358533biffins
boffin14359053boffi_n
boffing16339983boffing
boffos14568193boff_os
boffs134915503boff__s
bowfins15267703bowfins
buffets15317593buffets
coedits10310243coedits
coffees15329573coffees
coffers154112693coffers
coffin14339813coffi_n
coffing163811253coffing
coffles152610003coffles
coffrets1645363coffrets
coffs134916303coff__s
comfit133112423comfit_
commits133812383commits
confit113316403confit_
doffers14359853doffers
doffing15357793doffing
doffs125614333doff__s
doits66223673do__its
fits76043463___fits
flits85625223__flits
forfeits1445803forfeits
frits86129103__frits
godwits1234133godwits
goffers14409213goffers
haffets1636053haffets
haffit1538533haffit_
hobbits14317553hobbits
jiffies20327473jiffies
kaffirs17325553kaffirs
lofts85518363lo_f_ts
maffias15327283maffias
misfits12279663misfits
muffins15308343muffins
obits74617553_o_bits
offals1235893_offals
offcuts1542573_offcuts
offers12349963_offers
office1435693_office
offices1536243_offices
offing13368643_offing
offings14285833_offings
offish15137273_offish
offs107117013_off__s
offsets1333503_offsets
omits75018263_o_mits
orbits84211443_orbits
outfits102210833outfits
posits85718713po_sits
profits122911243profits
puffins15278913puffins
raffias13237713raffias
refits94017653_refits
roofies103014413roofies
schuits1235823schuits
scoffers16286133scoffers
scoffing17275943scoffing
scoffs14347503scoff__s
sennits73811283sennits
shafts125411443shaf_ts
shifts124412943shif_ts
shits84731173s__hits
shrifts1335963shrifts
sifts84918923s_if_ts
sits45050203s___its
skits94721863s__kits
slits56128853s__lits
snits54124833s__nits
sobeit8315363sobeit_
sockets134012983sockets
soddies92312853soddies
sofars94712783so_fars
sofas85320713so_f_as
soft76942823so_f_t_
softa86415183so_f_ta
softas94410403so_ftas
softens10347623softens
softest10310603softest
softie93312483softi_e
softish13127813softish
softy115414483so_f_ty
soils55327983so__ils
solicits10311023solicits
solids74116403so_lids
soloist7915893soloist
soloists869153soloists
somite84519373so_mite
somites94219123so_mites
sonants7511233sonants
sonics84315633so_nics
sonnets74211993sonnets
sonnies7315223sonnies
soots55536213so__ots
sophies12314613sophies
sophist12311563sophist
sophists1347293sophists
sopite84917713so_pite
sopites93817173so_pites
sorbets93012513sorbets
sorites73825243so_rites
sorties74126403sorties
sorts54536663so__rts
sots45552453so___ts
souffles14298123souffles
soviets1087293soviets
sozins15510793so_zins
spaits85017473s_paits
spiffies16277993spiffies
spirits94112623spirits
spits74429553s__pits
splits85416413s_plits
sprits85122533s_prits
stiffies14258383stiffies
straits74916323straits
submits1139753submits
suffers133113543suffers
suffice15197573suffice
suffices16208183suffices
suffix1935233suffi_x
suffixes21196353suffixes
suits55028053s__uits
sulfids1137293sulfids
sulfite10310473sulfite
sulfites1139903sulfites
summits1137983summits
surfeits1146223surfeits
swifts12408173swif_ts
taffias13377413taffias
taffies133012693taffies
tiffins13327983tiffins
toffees13327083toffees
toffs116016723toff__s
tofts84919243to_f_ts
toits55327473to__its
tomtits937243tomtits
tuffets13266523tuffets
unfits93910293_unfits
vomits112610923vo_mits
waffies163611443waffies
worrits10258683worrits
zaffirs22375663zaffirs

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.1601116818.8
2DLD Change Limit1340271586.71619956.4
3Display Results1581580.0632507.9
 (SQL Overall)1786911586.93925751.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.