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

247 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
tampered1327946(None) 
hampered16239931hampered
pampered15229231pampered
tamperer12248891tamperer
tapered102612931ta_pered
tempered13248221tempered
ampere10514412_ampere_
amperes11313982_amperes
bumpered1536002bumpered
cambered15129002cambered
capered123014042ca_pered
compered153414922compered
dampened1435622dampened
hammered16218852hammered
hamperer15379092hamperer
lappered13288212lappered
mammered12237652mammered
pamperer14228332pamperer
papered122513172pa_pered
paupered13216942paupered
scampered1635232scampered
simpered1338252simpered
stammered1444642stammered
stampeded15343922stampeded
tabered103311592ta_bered
tamped114317042tamp__ed
tamper104618512tamper__
tamperers13227312tamperers
tampers113516742tamper_s
tamponed1336022tamponed
taperer92511792ta_perer
tattered92011442tattered
temperer12227722temperer
timbered13137382timbered
yammered16225762yammered
abampere1442853abampere_
abamperes1563023abamperes
adhered1239233_adhered
altered83215743_altered
amerced1256523_am_erced
amped104820513_amp__ed
angered93013473_angered
appeared1336143_appeared
aspersed11428293_aspersed
aspired1068173_aspired
attempered1551773attempered
badgered1336213badgered
bannered11299323bannered
bantered113313633bantered
barbered13259543barbered
bartered113113013bartered
battered113315053battered
calipered1454873calipered
cameoed1238383cam_eoed
camped134720233camp__ed
camper124722213camper__
campers134220293camper_s
camporee1449343camporee
campused1535253campused
cancered132411553cancered
cankered153010223cankered
cantered113415983cantered
caperer113013403ca_perer
careered1139493careered
carpeted1338953carpeted
catered103117773ca_tered
chambered19145993chambered
chamfered20165063chamfered
clambered16146133clambered
compared153811823compared
compeered1646303compeered
compere134616623compere_
comperes143217973comperes
competed154113593competed
coopered133310933coopered
coppered153410543coppered
cumbered15157963cumbered
dackered16116893dackered
daggered12246403daggered
daikered1495223daikered
damped124315583damp__ed
dampener1335533dampener
damper114117753damper__
dampers123915693damper_s
dandered112110963dandered
dangered11248513dangered
dapperer1335763dapperer
diapered1238003diapered
faltered122810993faltered
fathered151510433fathered
gandered112211173gandered
garnered10247113garnered
gartered10319593gartered
gathered13149383gathered
haltered123112563haltered
hammerer15278143hammerer
hamper134518653hamper__
hamperers16287533hamperers
hampers143616953hamper_s
hankered16289443hankered
happened1635653happened
havered144011453ha_vered
homered133212713hom_ered
impeded13418183_impeded
jabbered2034433jabbered
kashered1636403kashered
kippered17255623kippered
laagered1055853laagered
lackered15108683lackered
laddered1136743laddered
lagered92311153la_gered
lamped114017543lamp__ed
lampers113817333lamper_s
lamperses1345123lamperses
lamprey1434863lamp_rey
lampyrid1642903lampyrid
lapeled10258893la_peled
lappeted13255833lappeted
lathered121512333lathered
laveered1235253laveered
lawyered1534033lawyered
layered11259413la_yered
limbered13158123limbered
lippered13287953lippered
loppered13326753loppered
lumbered13188233lumbered
mannered11249653mannered
mastered112614003mastered
mattered112412903mattered
membered1535903membered
nattered92011623nattered
numbered13147143numbered
paltered113012493paltered
pamper124316663pamper__
pamperers15236863pamperers
pampero13328093pamper_o
pamperos14306693pamperos
pampers133615933pamper_s
pandered121812573pandered
paperer113111903pa_perer
pattered112714203pattered
peppered1236133peppered
raftered1237663raftered
rampaged1434103rampaged
ramparted1443543ramparted
ramped114617903ramp__ed
rapiered1136053rapiered
rappeled1335003rappeled
retempered1543433retempered
sabered103213023sa_bered
saggered11237553saggered
sampled123410793samp_led
scamperer1544623scamperer
scarpered1435113scarpered
simmered1336863simmered
simperer1237173simperer
staggered1244473staggered
stamened1137633stam_ened
stammerer1344063stammerer
stamped124812813stamp__ed
stampede13326163stampede_
stampeder14304343stampeder
stampedes14315183stampedes
stamper113714403stamper__
stampers124211603stamper_s
steamered1244913steam_ered
stoppered1444473stoppered
summered1338143summered
supered10316123_supered
tableted1137533tableted
tabored102810563ta_bored
taboured1156273taboured
tafferel1443123tafferel
tailored936203tailored
tamboured1443783tamboured
tamed85528513tam___ed
tamer75230103tam_er__
tamers84224033tam_er_s
tampering1438453tampering
taped85327423ta_p__ed
taper74829773ta_per__
taperers10269773ta_perers
tapers84025813ta_per_s
tapped113820053ta_p_ped
tapper104419613tapper__
tappers113416543tapper_s
tared69340053ta___red
targeted1037483targeted
tarred74720283ta__rred
tarweed1137343tarwe_ed
tasseled935603tasseled
tautened935423tautened
teddered11255183teddered
teetered9258303teetered
telfered1234883telfered
telphered1544223telphered
temped113912893temp__ed
temper103914093temper__
tempera11329043temper_a
temperas12278233temperas
temperers13247023temperers
tempers113513013temper_s
tempested1444033tempested
templed12278563temp_led
tempted12317283temp_ted
tendered102510603tendered
tentered96412103tentered
tethered1238493tethered
tiered73613973t__iered
tillered937443tillered
tinkered1387683tinkered
tittered9239493tittered
tochered1437913tochered
tottered9208703tottered
towered112911403t_owered
trailered1045393trailered
trameled11309073tram_eled
trammeled1453203trammeled
tramped124312433tramp__ed
tramper113812163tramper__
trampers123210393tramper_s
trampled13247903tramp_led
trapesed1136473trapesed
trumpeted1443053trumpeted
tuckered1535963tuckered
tumped114216233tump__ed
umbered121510113_umbered
umpired1235783_umpired
unhampered1853133unhampered
untempered1544043untempered
vamped144211013vamp__ed
vamper134212653vamper__
vampers143111623vamper_s
vampire14296673vampire_
vampires15226033vampires
vapored1336923va_pored
wafered14288433wa_fered
wagered12299333wa_gered
waitered1238753waitered
wandered132110793wandered
watered113014953wa_tered
wavered142910433wa_vered
whimpered20144023whimpered
yabbered1633963yabbered
yammerer15225483yammerer
yattered12239533yattered
zippered22244823zippered

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.403443402.0
2DLD Change Limit1461622476.89321204.4
3Display Results2472470.1102245.5
 (SQL Overall)1786912477.40624127.9
 
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.