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

137 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
temperer1222772(None) 
tamperer12248891tamperer
tempered13248221tempered
temperers13247021temperers
emperor1155482_emperor
hamperer15379092hamperer
pamperer14228332pamperer
pepperer1145282pepperer
simperer1237172simperer
tampered13279462tampered
tamperers13227312tamperers
taperer92511792t_aperer
temper103914092temp__er
tempera11329042temper_a
temperas12278232temperas
tempers113513012temper_s
tempter11358212temp_ter
tenderer9228732tenderer
ampere10514413_ampere_
amperes11313983_amperes
attempered1551773attempered
bumpered1536003bumpered
caperer113013403_caperer
comparer143611363comparer
compeer133811553compe_er
compere134616623compere_
compered153414923compered
comperes143217973comperes
cumberer14266993cumberer
dampener1335533dampener
dapperer1335763dapperer
deepener1145183deepener
demerger12127373dem_erger
dempster1355773dempster
demurer1037873dem_urer
demurrer1144043demurrer
eagerer8248823_eagerer
emeer74815363_em_e_er
empaler11288353_empaler
emperies12314563_emperies
emperors1256123_emperors
empery1348683_emper_y
empire1039323_empire_
empires1139853_empires
empower14217033_empower
emptier1187603_emptier
enterer72015633_enterer
expirer1635993_expirer
fetterer11207813fetterer
hammerer15278143hammerer
hampered16239933hampered
hamperers16287533hamperers
hempier14319003hemp_ier
impeder12438533_impeder
impurer1136483_impurer
jeerer13389933je__erer
kipperer16294723kipperer
letterer8259223letterer
limberer12187053limberer
lumberer12177583lumberer
membered1535903membered
merer75126233__m_erer
numberer12186313numberer
pampered15229233pampered
pamperers15236863pamperers
paperer113111903_paperer
peppered1236133peppered
pepperers1244903pepperers
pesterer102412703pesterer
pewterer13256313pewterer
properer1259203properer
renderer9239743renderer
retempered1543433retempered
reverer103815833re_verer
scamperer1544623scamperer
sempre102710093semp_re_
severer103511563se_verer
simpered1338253simpered
simperers1335933simperers
stammerer1344063stammerer
stampeder14304343stampeder
steerer73113633ste__erer
tamper104618513tamp__er
tampers113516743tamper_s
tapered102612933t_apered
taperers10269773t_aperers
tearer64822903te__arer
teaseler8176573teaseler
teddered11255183teddered
teemer85515743te__emer
teener64717503te__ener
teepee8314363teepe_e_
teepees939263teepe_es
teeter65420313te__eter
teetered9258303teetered
telfered1234883telfered
telpher1235563telp_her
telphered1544223telphered
temped113912893temp__ed
tempeh13357463temp__eh
tempehs14325153tempe_hs
temperate1348513temperate
tempering1438733tempering
tempest1139223tempe_st
tempested1444033tempested
tempests1234443tempests
templar1145643temp_lar
temple102811333temp_le_
templed12278563temp_led
temples112610893temp_les
templet112712003temp_let
temporal1246333temporal
temporary1653203temporary
temporizer2345233temporizer
tempted12317283temp_ted
tempters12257293tempter_s
temptress1343133temptress
tempura11295253tempur_a
tempuras12295063tempuras
tendered102510603tendered
tenderers10227803tenderers
tentered96412103tentered
tepee74724213te_pe_e_
tepees84215243te_pe_es
terpene92310863terpene_
terpenes102111573terpenes
tethered1238493tethered
timbered13137383timbered
tinkerer1286803tinkerer
titterer8268523titterer
totterer8217793totterer
trumpeter1343153trumpeter
untempered1544043untempered
veneerer1145033veneerer
verderer1245373verderer
whimperer19123723whimperer
yammerer15225483yammerer

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 Limit1461621376.78021557.8
3Display Results1371370.0632174.6
 (SQL Overall)1786911377.26624592.8
 
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.