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

207 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
hammered1621884(None) 
hammerer15278141hammerer
hampered16239921hampered
mammered12237651mammered
yammered16225761yammered
cambered15128992cambered
chambered19145982chambered
chamfered20165052chamfered
haltered123112552haltered
hammed144116972hamm__ed
hammer138120032hammer__
hammerers16216552hammerers
hammerhead2152182hammerhead
hammers144216052hammer_s
hamperer15379092hamperer
hankered16289442hankered
havered144011452ha_vered
homered133212712h_omered
pampered15229222pampered
rehammered1843082rehammered
shimmered1744782shimmered
simmered1336862simmered
stammered1444642stammered
summered1338142summered
tampered13279462tampered
yammerer15225482yammerer
adhered1239233_adhered
admired1135703_admired
altered83215733_altered
amerced1256523_a_merced
ammeter1148393_ammeter
ampere10514413_ampere_
amperes11313983_amperes
angered93013473_angered
armored102610473_armored
badgered1336213badgered
bammed133913243bamm__ed
bannered11299323bannered
bantered113313633bantered
barbered13259543barbered
bartered113113013bartered
battered113315053battered
bumpered1536003bumpered
cameoed1238383ca_meoed
cancered132411553cancered
cankered153010223cankered
cantered113415983cantered
capered123014043ca_pered
careered1139493careered
catered103117763ca_tered
chaffered21154473chaffered
chamferer19154683chamferer
chammied18215963chamm_ied
chaptered17176783chaptered
chartered15158383chartered
chattered15197983chattered
clambered16146123clambered
commerced18125463commerced
compered153414923compered
cumbered15157953cumbered
dackered16116893dackered
daggered12246403daggered
daikered1495223daikered
dammed124214793damm__ed
dammer114317933dammer__
dammers123214273dammer_s
dampened1435623dampened
dandered112110963dandered
dangered11248513dangered
dormered1255673dormered
faltered122810983faltered
fathered151510433fathered
gammed124216163gamm__ed
gammer1112318333gammer__
gammers123214563gammer_s
gammoned1444993gammoned
gandered112211173gandered
garnered10247113garnered
gartered10319583gartered
gathered13149373gathered
glimmered1543103glimmered
hachured1744393hachured
haeres94017033ha__eres
haired105117173ha__ired
halberd1336043halber_d
haltere103614703haltere_
halteres113414593halteres
hamboned1637003hamboned
hammerheads2251733hammerheads
hammering1737623hammering
hammerkop2251113hammerkop
hammerless1742363hammerless
hammertoe1652263hammertoe
hammertoes1752413hammertoes
hammier143510653hamm_ier
hamper134518653hamper__
hamperers16287523hamperers
hampers143616943hamper_s
hangared1337563hangared
hankerer15248233hankerer
hanseled1237713hanseled
happened1635653happened
harbored1438633harbored
hardened1338613hardened
hared95742183ha___red
harkened1637483harkened
harmed125218833harm__ed
harmer114719553harmer__
harmers124116593harmer_s
hastened12239103hastened
hatred104814333ha__tred
havened14429243ha_vened
haverel13397153ha_verel
hawkeyed2242403hawkeyed
hayseed1435633hayse_ed
heathered16149463heathered
helmeted1435833helmeted
hemmed144211463hemm__ed
hemmer134112643hemmer__
hemmers143310843hemmer_s
hindered1339453hindered
hollered1237603hollered
homebred16215893homebred
hoovered15195413hoovered
hovered143411573h_overed
hummed144812673humm__ed
hummer133615273hummer__
hummers143813063hummer_s
humored1336723h_umored
humoured1444363humoured
hungered13217053hungered
hunkered16186923hunkered
immerged1444023_immerged
immersed1344833_immersed
immured1235063_immured
jabbered2034433jabbered
jammed183811503jamm__ed
jammer174014133jammer__
jammers183710703jammer_s
kashered1636403kashered
laagered1055853laagered
lackered15108673lackered
laddered1136743laddered
lagered92311153la_gered
lammed113915623lamm__ed
lappered13288213lappered
lathered121512323lathered
laveered1235253laveered
lawyered1534033lawyered
layered11259413la_yered
limbered13158113limbered
lumbered13188233lumbered
mammee94417853mamme_e_
mammees104411143mamme_es
mammer94218863mammer__
mammers104615693mammer_s
mannered11249653mannered
mastered112614003mastered
mattered112412903mattered
membered1535903membered
nattered92011623nattered
numbered13147143numbered
paltered113012483paltered
pamperer14228333pamperer
pandered121812573pandered
papered122513163pa_pered
pattered112714203pattered
paupered13216933paupered
pommeled1543103pommeled
pummeled1543373pummeled
raftered1237663raftered
rammed113117303ramm__ed
rammer103519653rammer__
rammers113715043rammer_s
rapiered1136053rapiered
sabered103213023sa_bered
saggered11237553saggered
scampered1635233scampered
shammed153911423shamm__ed
shammer144613143shammer__
shammers153710833shammer_s
shammied16265543shamm_ied
shattered13178203shattered
simpered1338253simpered
stammerer1344063stammerer
tabered103311593ta_bered
tamperer12248893tamperer
tapered102612933ta_pered
tattered92011443tattered
tempered13248213tempered
timbered13137383timbered
trammeled1453203trammeled
umbered121510113_umbered
unhampered1853133unhampered
wafered14288433wa_fered
wagered12299333wa_gered
waitered1238753waitered
wandered132110793wandered
watered113014953wa_tered
wavered142910433wa_vered
whammed18345133whamm__ed
whimpered20144023whimpered
yabbered1633963yabbered
yammer133713183yammer__
yammerers16214453yammerers
yammers143410323yammer_s
yattered12239533yattered

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.1731032896.0
2DLD Change Limit1461622078.76616673.7
3Display Results2072070.0932225.8
 (SQL Overall)1786912079.03219784.2
 
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.