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

241 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
hampered1623992(None) 
hammered16218841hammered
hamperer15379091hamperer
pampered15229221pampered
tampered13279461tampered
ampere10514412_ampere_
amperes11313982_amperes
bumpered1536002bumpered
cambered15128992cambered
capered123014042ca_pered
chambered19145982chambered
chamfered20165052chamfered
compered153414922compered
dampened1435622dampened
haltered123112552haltered
hammerer15278142hammerer
hamper134518652hamper__
hamperers16287522hamperers
hampers143616942hamper_s
hankered16289442hankered
happened1635652happened
havered144011452ha_vered
homered133212712hom_ered
lappered13288212lappered
mammered12237652mammered
pamperer14228332pamperer
papered122513162pa_pered
paupered13216932paupered
scampered1635232scampered
simpered1338252simpered
tamperer12248892tamperer
tapered102612932ta_pered
tempered13248212tempered
unhampered1853132unhampered
whimpered20144022whimpered
yammered16225762yammered
abampere1442853abampere_
abamperes1563023abamperes
adhered1239233_adhered
altered83215733_altered
amerced1256523_am_erced
amped104820513_amp__ed
angered93013473_angered
appeared1336143_appeared
aspersed11428293_aspersed
aspired1068173_aspired
badgered1336213badgered
bannered11299323bannered
bantered113313633bantered
barbered13259543barbered
bartered113113013bartered
battered113315053battered
calipered1454873calipered
cameoed1238383cam_eoed
camped134720233camp__ed
camper124722213camper__
campers134220283camper_s
camporee1449343camporee
campused1535253campused
cancered132411553cancered
cankered153010223cankered
cantered113415983cantered
caperer113013403ca_perer
careered1139493careered
carpeted1338943carpeted
catered103117763ca_tered
chaffered21154473chaffered
chamferer19154683chamferer
champed174111473champ__ed
champer163813403champer__
champers173311613champer_s
champerty2142873champerty
chaptered17176783chaptered
chartered15158383chartered
chattered15197983chattered
chippered1945003chippered
choppered1964883choppered
clambered16146123clambered
compared153811823compared
compeered1646303compeered
compere134616623compere_
comperes143217973comperes
competed154113593competed
coopered133310933coopered
coppered153410543coppered
cumbered15157953cumbered
dackered16116893dackered
daggered12246403daggered
daikered1495223daikered
damped124315583damp__ed
dampener1335533dampener
damper114117753damper__
dampers123915693damper_s
dandered112110963dandered
dangered11248513dangered
dapperer1335763dapperer
diapered1238003diapered
faltered122810983faltered
fathered151510433fathered
gandered112211173gandered
garnered10247113garnered
gartered10319583gartered
gathered13149373gathered
hachured1744393hachured
haeres94017033ha__eres
haired105117173ha__ired
halberd1336043halber_d
haltere103614703haltere_
halteres113414593halteres
hamboned1637003hamboned
hammed144116973ham__med
hammer138120033hammer__
hammerers16216553hammerers
hammerhead2152183hammerhead
hammers144216053hammer_s
hampering1738853hampering
hangared1337563hangared
hankerer15248233hankerer
hanseled1237713hanseled
happed144820103ha_p_ped
harbored1438633harbored
hardened1338613hardened
hared95742183ha___red
harkened1637483harkened
harped124418403harp__ed
harper115018403harper__
harpers124916203harper_s
hasped125014443hasp__ed
hastened12239103hastened
hatred104814333ha__tred
havened14429243ha_vened
haverel13397153ha_verel
hawkeyed2242403hawkeyed
hayseed1435633hayse_ed
heathered16149463heathered
hempseed1643603hempseed
hempweed1942793hempweed
hindered1339453hindered
hollered1237603hollered
homebred16215893homebred
hoovered15195413hoovered
hovered143411573h_overed
humored1336723hum_ored
humoured1444363humoured
humped144015243hump__ed
humper134115883humper__
humpers142713523humper_s
humphed1835423hump_hed
hungered13217053hungered
hunkered16186923hunkered
impeded13418183_impeded
jabbered2034433jabbered
kashered1636403kashered
kippered17255623kippered
laagered1055853laagered
lackered15108673lackered
laddered1136743laddered
lagered92311153la_gered
lamped114017543lamp__ed
lampers113817333lamper_s
lamperses1345123lamperses
lamprey1434863lamp_rey
lampyrid1642903lampyrid
lapeled10258893la_peled
lappeted13255833lappeted
lathered121512323lathered
laveered1235253laveered
lawyered1534033lawyered
layered11259413la_yered
limbered13158113limbered
lippered13287953lippered
loppered13326753loppered
lumbered13188233lumbered
mannered11249653mannered
mastered112614003mastered
mattered112412903mattered
membered1535903membered
nattered92011623nattered
numbered13147143numbered
paltered113012483paltered
pamper124316663pamper__
pamperers15236863pamperers
pampero13328093pamper_o
pamperos14306693pamperos
pampers133615933pamper_s
pandered121812573pandered
paperer113111903pa_perer
pattered112714203pattered
peppered1236113peppered
raftered1237663raftered
rampaged1434103rampaged
ramparted1443543ramparted
ramped114617903ramp__ed
rapiered1136053rapiered
rappeled1335003rappeled
rehammered1843083rehammered
sabered103213023sa_bered
saggered11237553saggered
sampled123410783samp_led
scamperer1544623scamperer
scarpered1435103scarpered
shampooed1742943shampooed
sharpened1544473sharpened
shattered13178203shattered
shimmered1744783shimmered
simmered1336863simmered
simperer1237173simperer
stammered1444643stammered
stampeded15343923stampeded
summered1338143summered
supered10316123_supered
tabered103311593ta_bered
tamped114317043tamp__ed
tamper104618513tamper__
tamperers13227313tamperers
tampers113516743tamper_s
tamponed1336023tamponed
taperer92511793ta_perer
tattered92011443tattered
temperer12227723temperer
timbered13137383timbered
umbered121510113_umbered
umpired1235783_umpired
vamped144211013vamp__ed
vamper134212653vamper__
vampers143111623vamper_s
vampire14296673vampire_
vampires15226033vampires
vapored1336923va_pored
wafered14288433wa_fered
wagered12299333wa_gered
waitered1238753waitered
wandered132110793wandered
watered113014953wa_tered
wavered142910433wa_vered
whimperer19123723whimperer
whispered18144373whispered
yabbered1633963yabbered
yammerer15225483yammerer
yattered12239533yattered
zippered22244823zippered

Search took 10 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.1701051123.5
2DLD Change Limit1461622418.98616265.5
3Display Results2412410.1102190.9
 (SQL Overall)1786912419.26619284.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.