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 “koshered” 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.

138 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
koshered163606(None) 
coshered14610291coshered
kashered1636401kashered
bothered142110392bothered
cohered133514692co_hered
fostered122210452fostered
kosher134412972kosher__
koshers144811802kosher_s
mothered142310102mothered
ochered132610282_ochered
osiered837122_osiered
pothered142311042pothered
tochered1437912tochered
ushered1139152_ushered
adhered1239233_adhered
answered1235493answered
ashlered1244623_ashlered
bistered112913333bistered
bolstered1246093bolstered
bordered1248933bordered
bowered133113043bo_wered
brothered1546003brothered
busheled1465273busheled
cashiered1543403cashiered
ciphered1637053ciphered
cockered17710213cockered
coffered1737673coffered
cohere112716993co_here_
coherer122912783co_herer
coheres122917693co_heres
coinhered1536593coinhered
compered153414923compered
coopered133310933coopered
coppered153410543coppered
cornered11311133cornered
coshed124217543cosh__ed
cosher114819903cosher__
coshers123618183cosher_s
cosseted1178343cosseted
cottered112511733cottered
covered133315293co_vered
cowered133214653co_wered
cowherd1636953cowher_d
cyphered1934653cyphered
dithered13189293dithered
doddered1234943doddered
donnered10307753donnered
dormered1255673dormered
dosseret91111513dosseret
dowered122811553do_wered
ensphered1565283ensphered
fathered151510433fathered
festered122512113festered
foddered1434553foddered
fosterer11239523fosterer
gathered13149383gathered
goffered1634523goffered
hollered1237603hollered
holstered1345883holstered
homered133212713ho_mered
hoovered15195413hoovered
hoseyed1436953hos_eyed
hosteled1237293hosteled
hovered143411573ho_vered
inhered11313163_inhered
insphered1564783insphered
joshed174610903josh__ed
josher164312963josher__
joshers174111593josher_s
kasher134915033kasher__
kashers143914023kasher_s
kippered17255623kippered
koshering1735363koshering
lathered121512333lathered
lechered1437523lechered
lobstered1244643lobstered
loitered938183loitered
loppered13326753loppered
louvered1244993louvered
lowered112711913lo_wered
lustered92510603lustered
mastered112614003mastered
moldered1237173moldered
mongered1238953mongered
moseyed1336133mos_eyed
moshed124517493mosh__ed
mosher114719793mosher__
moshers124017843mosher_s
mustered112511503mustered
noshed104413503nosh__ed
nosher94616363nosher__
noshers103614333nosher_s
nowhere1337213nowhere_
nowheres1437513nowheres
ochred12328003_och_red
offered1436143_offered
oosphere1355993oosphere_
oospheres1456633oospheres
ordered9108533_ordered
overed102216623_o_vered
oystered1236923oystered
pestered112814973pestered
pondered126411293pondered
portered112311543portered
posher115018163posher__
postured1139493postured
potsherd1434813potsher_d
pottered112311663pottered
powdered15256893powdered
powered132911643po_wered
prospered1446973prospered
rogered939553ro_gered
roistered1037643roistered
roystered1344873roystered
sered65737293__s_ered
shared105829063__shared
sheared114516003__sheared
sheered113515453__sheered
sherd96321153__sher_d
shewed134716183__shewed
shored105723653__shored
shred98125613__sh_red
sistered92612803sistered
smothered1545683smothered
sobered102912433so_bered
soldered1038153soldered
sphered133512313_sphered
syphered1755013syphered
tethered1238493tethered
tottered9208703tottered
towered112911403to_wered
unshared121510703unshared
unsphered1556103unsphered
vouchered1843853vouchered
westered122511873westered
withered15169433withered
wondered13239943wondered
wuthered15157433wuthered

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621387.36019859.0
3Display Results1381380.0463000.0
 (SQL Overall)1786911387.82922824.2
 
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.