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

279 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
tempters1225729(None) 
tempers113513011temp_ers
tempter11358211tempter_
attempters1442662attempters
dempsters1435272dempsters
emoters94712872_emoters
emptiers1275192_emptiers
hemipters1645682hemipters
sumpters1238022sumpters
tampers113516742tamp_ers
teamsters1135972teamsters
teeters74018302te_eters
telphers1335472telphers
tempehs14325152temp_ehs
temper103914092temp_er_
tempera11329042temp_era
temperas12278232temp_eras
temperers13247022temperers
templars1255262templars
temples112610892temple_s
templets12226142templets
tempted12317282tempte_d
temptress1343132temptress
tempts10439452tempt__s
tenters73921102te_nters
testers74124542te_sters
tetters74320472te_tters
adapters1136103adapters
adopters1136693adopters
ammeters1237693ammeters
attempers13103503attemp_ers
attempter1342963attempter_
beaters94925043be_aters
beepers113612383beep_ers
belters93819413be_lters
betters94422093be_tters
bumpers133912053bump_ers
campers134220293camp_ers
cementers1338313cementers
cemetery1554923cemetery
centers94420603ce_nters
chapters154012133chapters
compeers143410013compeers
computers15339753computers
copters113621283_copters
dampers123915693damp_ers
debaters113511923debaters
deemsters1285023deemsters
demisters1249203demisters
demotes104717673demote_s
dempster1355773dempster_
deters74724683de__ters
dewaters122910723dewaters
dimeters11411093dimeters
diopters1137693diopters
dumpers123412663dump_ers
dumpsters1453743dumpsters
easters75125683_easters
eaters65535953_e_aters
elaters74420193_elaters
embers104116183_em_bers
emeers83314183_em_eers
emitters10349643_emitters
emmers104013223_em_mers
emoter85415193_emoter_
emotes84620283_emote_s
empalers12226743_empalers
empery1348683_emp_ery
empires1139853_empires
empowers15276843_empowers
empress1138163_empress
emptier1187603_emptier_
empties11712243_empties
emptins1179403_emptins
enters64425643_e_nters
esters64627733_e_sters
feasters11511563feasters
festers104121393fe_sters
fetters103517903fe_tters
gemotes103712143gemote_s
geometers1238193geometers
getters84216103ge_tters
hampers143616953hamp_ers
hamsters13710423hamsters
heapers123616673heap_ers
heaters104225223he_aters
hefters134312003he_fters
heisters113413133heisters
helpers123311853help_ers
hemipter1545583hemipter_
hemmers143310843hem_mers
hempier14319003hempier_
humpers142713523hump_ers
imputers1235823_imputers
itemizers20133293itemizers
jeepers16399193jeep_ers
jesters144118193je_sters
jumpers18399843jump_ers
keepers133410983keep_ers
keesters12319593keesters
keisters123212043keisters
kelters113813753ke_lters
keysters15326333keysters
lampers113817333lamp_ers
lamsters1099753lamsters
leapers93716663leap_ers
leisters83312823leisters
lepers84817323le_p_ers
letters73819853le_tters
limiters10249333limiters
limpers113815223limp_ers
lumpers113514483lump_ers
maters85032393__maters
meeters94714543me_eters
meisters103313843meisters
melters93918313me_lters
members13258603mem_bers
meters85625833__meters
miters84328783__miters
mumpers133311373mump_ers
negaters9349783negaters
nesters74422793ne_sters
netters73618583ne_tters
neuters74212273ne_uters
pampers133615933pamp_ers
peepers113713673peep_ers
pelters93720313pe_lters
pensters103012123pensters
peoplers1237163peoplers
peppers103311443pe_ppers
peripters1368123peripters
pesters93827093pe_sters
peters86624593pe__ters
petters93722363pe_tters
pewters124113353pe_wters
prompters1537553prompters
pumpers133113673pump_ers
ratemeters1244993ratemeters
realters83614043realters
reapers93520453reap_ers
rebaters103413943rebaters
reciters102613113reciters
reenters82915303reenters
refuters11449613refuters
reinters82614773reinters
relaters83218153relaters
remakers143811303remakers
remasters11310583remasters
remates93827113remate_s
remitters11328403remitters
remoter94815973remoter_
remotes94521613remote_s
removers13449223removers
renters74224813re_nters
resters74130403re_sters
retempers1345023retemp_ers
reutters8138573reutters
rompers113412243romp_ers
samplers12299403samplers
scepters1237793scepters
seamsters1136333seamsters
seaters74028943se_aters
semesters1139123semesters
septets998953se_ptets
setters73822063se_tters
simpers113014123simp_ers
smelters103310513smelters
smiters93414363_smiters
stampers124211603stamp_ers
steepers103011373steep_ers
stemmers12378443stem_mers
steppers12289283ste_ppers
stompers123610043stomp_ers
stumpers12318313stump_ers
sumpter1138873sumpter_
tamers84224033tam__ers
tamper104618513tamp_er_
tamperers13227313tamperers
tapers84025813t_ap_ers
tappers113416543t_appers
tapsters10318803tapsters
tasters74225643t_asters
taters64932203t__aters
tatters74520483t_atters
taunters8259273taunters
teachers133212393teachers
teamakers1544873teamakers
teamster1036293teamster_
tearers75218233te_arers
teasers75317243te_asers
tedders94010233te_dders
teemers95012903te_emers
teeners74415453te_eners
teepees939263teep_ees
teeter65420313te_eter_
teethers11328713teethers
telemeters1246683telemeters
telfers10299073te_lfers
tellers73717593te_llers
telpher1235563telpher_
temblors1244463temblors
temped113912893temp_e_d
tempeh13357463temp_e_h
tempered13248223temp_ered
temperer12227723temp_erer
tempest1139223temp_est
tempests1234443tempests
templar1145643templar_
templates1348273template_s
temple102811333temple__
templed12278563temple_d
templet112712003temple_t
tempos103812293temp__os
temps95417133temp___s
tempt95124843tempt___
tempting1357343tempting
tempura11295253temp_ura
tempuras12295063tempuras
tenders83719723te_nders
tenners74014923te_nners
tenoners858713tenoners
tenter64623933te_nter_
tepees84215243te_p_ees
termers95414503te_rmers
termites10313693termite_s
terriers84210823terriers
testees74215913te_stees
tester64227153te_ster_
testes65125823te_ste_s
tethers103815313te_thers
tetter64322453te_tter_
theaters114211903theaters
thumpers15365713thump_ers
tilters73315953t_ilters
timbers113111853tim_bers
timers84420993tim__ers
tinters74221113t_inters
tippers113414353t_ippers
tipplers12336353tipplers
tipsters10278513tipsters
titers64526413t__iters
titters74219623t_itters
toasters83912723toasters
tooters73818773t_ooters
topers85025323t_op_ers
toppers113914603t_oppers
toters65026363t__oters
totters74618733t_otters
touters74018353t_outers
trampers123210393tramp_ers
tramplers13305883tramplers
trappers123711043trappers
treaters83615843treaters
tremblers1334483tremblers
trimeters1139213trimeters
trippers123210163trippers
trotters83310243trotters
trumpeters1442633trumpeters
trusters83112263trusters
trysters11298373trysters
tufters10298353t_ufters
tumblers123110623tumblers
tummlers12295703tummlers
tweeters11287143tweeters
twisters11268173twisters
twitters11296773twitters
unmiters1037073unmiters
vampers143111623vamp_ers
venters103717733ve_nters
vespers1239033vesp_ers
vetters104016323ve_tters
vomiters1337203vomiters
websters1335803websters
weepers123511973weep_ers
welters103516063we_lters
westers105221963we_sters
wetters103817753we_tters
yelpers12348203yelp_ers
zesters163517293ze_sters

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622797.45319611.2
3Display Results2792790.1102536.4
 (SQL Overall)1786912797.96922423.3
 
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.