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

105 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
simperers133593(None) 
simperer1237171simperer_
hamperers16287532hamperers
impeders13346592_impeders
kipperers17233822kipperers
pamperers15236862pamperers
scamperers1643472scamperers
silverers12215752silverers
simpered1338252simpere_d
simpers113014122simp__ers
tamperers13227312tamperers
temperers13247022temperers
whimperers20122972whimperers
amperes11313983_ampere_s
bickerers17115593bickerers
caperers122611723_caperers
cipherers1644893cipherers
comparers15319393comparers
compeers143410013compe_ers
comperes143217973compere_s
cumberers15176003cumberers
dampeners1444663dampeners
dimeters11411093dim_eters
dispersers13137423dispersers
ditherers13196683ditherers
emperors1256123_emperors
filterers12206973filterers
fingerers13136303fingerers
hammerers16216563hammerers
hamperer15379093hamperer_
hinderers1337353hinderers
impairers1343713_impairers
impalers12226973_impalers
imparters13276573_imparters
impeder12438533_impeder_
impedes124310093_impede_s
impellers1345103_impellers
imperils1247713_imperils
implorers13124413_implorers
importers13247763_importers
imposers12278463_imposers
impowers15296823_impowers
impress1137773_imp_ress
impurer1136483_impurer_
imputers1235823_imputers
kipperer16294723kipperer_
limberer12187053limberer_
limpers113815223limp__ers
lingerers10126923lingerers
litterers9228193litterers
lumberers13196013lumberers
miterers10219683mi_terers
numberers13165153numberers
pamperer14228333pamperer_
paperers122410453_paperers
pepperers1244893pepperers
pilferers1444583pilferers
pimpernels1642173pimpernels
ripeners1036833ri_peners
samplers12299403samp_lers
scamperer1544623scamperer_
shiverers15155773shiverers
showerers1545073showerers
sickeners1535733sickeners
silverer11216733silverer_
simmered1336863simmere_d
simmers113314613sim__mers
simper103616293simp__er_
simpering1449293simpering
simpleness1445173simpleness
simpler112910863simp_ler_
simples113014943simp_le_s
simplexes2043983simplexe_s
sincerer1037203sincerer_
sippers113117753si_p_pers
slaverers12165993slaverers
sliverers12196363sliverers
slumberers14203683slumberers
smearers10308623s_mearers
sneerers8309803s_neerers
snickerers16133583snickerers
sniggerers1242193sniggerers
solderers1066533solderers
sorcerers1145323sorcerers
sparers94519613s__parers
spearers103711143s__pearers
speers85019953s__pe_ers
spewers124210653s__pewers
stammerers1443133stammerers
stampeders15233203stampeders
steerers82511353s_teerers
sufferers1555103sufferers
sumpters1238023sump_ters
sunderers1039073sunderers
swimmerets1751623swimmerets
tamperer12248893tamperer_
taperers10269773_taperers
temperer12227723temperer_
tinkerers1395423tinkerers
titterers9236993titterers
whimperer19123723whimperer_
whisperers18153053whisperers
winterers12209723winterers
witherers15146843witherers
yammerers16214453yammerers

Search took 9 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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411057.89018839.2
3Display Results1051050.0462282.6
 (SQL Overall)1786911058.09222082.4
 
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.