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

303 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
haltered12311255(None) 
altered83215731_altered
faltered122810981faltered
haltere103614701haltere_
halteres113414591halteres
paltered113012481paltered
alterer72713992_alterer
bantered113313632bantered
bartered113113012bartered
battered113315052battered
cantered113415982cantered
catered103117772ca_tered
chaptered17176792chaptered
chartered15158392chartered
chattered15197992chattered
falterer11239852falterer
filtered12259042filtered
gartered10319582gartered
halberd1336052halber_d
halted105019602halt__ed
halter94420882halter__
halters104619802halter_s
hammered16218852hammered
hampered16239932hampered
hankered16289442hankered
hastened12239102hastened
hatred104814332ha_t_red
havered144011452ha_vered
hollered1237602hollered
holstered1345882holstered
mastered112614002mastered
mattered112412902mattered
nattered92011622nattered
palterer102411272palterer
pattered112714202pattered
peltered112510452peltered
philtered1545492philtered
raftered1237662raftered
realtered1037892realtered
shattered13178202shattered
sheltered1335572sheltered
tattered92011442tattered
unaltered1037722unaltered
waitered1238752waitered
watered113014952wa_tered
weltered12238432weltered
yattered12239532yattered
adhered1239233_adhered
alerted82512223_al_erted
aliened81011743_aliened
alleged9389323_alleged
allured8299173_allured
alter54828503_alter__
alterers82512493_alterers
alters64924223_alter_s
angered93013473_angered
anteed75616113_ante_ed
antired82316193_antired
antlered938263_antlered
attired8238913_attired
badgered1336213badgered
bannered11299323bannered
banterer102811773banterer
barbered13259543barbered
barterer102711633barterer
battened11259573battened
batterer102713213batterer
bettered113011833bettered
bistered112913323bistered
bittered112711833bittered
blathered15168353blathered
blattered12198563blattered
blazered2035063blazered
bolstered1246093bolstered
buttered112712623buttered
calibred1335053calibred
calipered1454873calipered
cambered15129003cambered
cancered132411553cancered
cankered153010223cankered
capered123014043ca_pered
captured1336573captured
careered1139493careered
caterer92815943ca_terer
centered112513523centered
chaffered21154483chaffered
chambered19145993chambered
chamfered20165063chamfered
charterer14197323charterer
chastened1545883chastened
chatterer14196843chatterer
chittered15166413chittered
chuntered1536663chuntered
clattered12178403clattered
clavered14187633clavered
cottered112511733cottered
cratered1149683cratered
cultured1137233cultured
dackered16116893dackered
daggered12246403daggered
daikered1495223daikered
dandered112110963dandered
dangered11248513dangered
elaterid948613elaterid
entered82718883_entered
factored1436213factored
falter94519053falter__
falterers12238033falterers
falters103916473falter_s
fastened12257853fastened
fathered151510433fathered
fattened12268283fattened
festered122512103festered
fettered12259493fettered
filterer11258143filterer
flattered13188623flattered
fleered11309503_fleered
fostered122210453fostered
fullered1236383fullered
galere73716673gal_ere_
galeres83514333gal_eres
galleried1146923galleried
galleted1038213galleted
gandered112211173gandered
garnered10247113garnered
gathered13149373gathered
gettered10258613gettered
guttered10259163guttered
hachured1744393hachured
haeres94017033ha__eres
hafted134713833haft__ed
hafter124815883hafter__
hafters134614333hafter_s
haired105117173ha__ired
halberds1435183halberds
halbert12314503halber_t
halberts1335973halberts
haled95335823hal___ed
haler85033523hal_er__
halers94926913hal_er_s
haleru94212073hal_er_u
halloaed121510153halloaed
halloed113314913hal_loed
hallooed12168773hallooed
hallowed15179493hallowed
haloed104717603hal__oed
haltering132212003haltering
halved134813903hal__ved
halvers133311423halver_s
halyard1476973halyar_d
hammerer15278143hammerer
hamperer15379093hamperer
hangared1337573hangared
hankerer15248233hankerer
hanseled1237713hanseled
hanted104124313hant__ed
happened1635653happened
haptene123810933haptene_
haptenes133810823haptenes
harbored1438633harbored
hardened1338613hardened
hared95742183ha___red
harkened1637483harkened
hasted105125283hast__ed
hastener11259133hastener
hatched163414463ha_tched
hated95734023ha_t__ed
hater85034753ha_ter__
haters94930403ha_ter_s
hatreds11307813ha_t_reds
hatted104921513ha_t_ted
hatter94724873hatter__
hatteria1137863hatteria
hatters104221523hatter_s
havened14429243ha_vened
haverel13397153ha_verel
hawkeyed2242403hawkeyed
hayseed1435633hayse_ed
heartened1347063heartened
heathered16149463heathered
hectored1436873hectored
helmeted1435833helmeted
hilted104016043hilt__ed
hindered1339453hindered
homered133212713h_omered
hoovered15195413hoovered
hosteled1237283hosteled
hovered143411573h_overed
hungered13217053hungered
hunkered16186923hunkered
jabbered2034433jabbered
jittered16267223jittered
kashered1636403kashered
laagered1055853laagered
lackered15108673lackered
laddered1136743laddered
lagered92311153la_gered
lappered13288213lappered
latened8711923la_tened
laterad8310843la_terad
lathered121512323lathered
laveered1235253laveered
lawyered1534033lawyered
layered11259413la_yered
leered73816223__leered
lettered92910783lettered
littered92511383littered
loitered938183loitered
lustered92510603lustered
malted94819863malt__ed
mammered12237653mammered
mannered11249653mannered
martyred1434283martyred
matured10310033ma_tured
metered103514013_metered
misaltered1344563misaltered
mitered103213233_mitered
moldered1237173moldered
mustered112511503mustered
muttered112610793muttered
natured838963na_tured
neutered937423neutered
oystered1236923oystered
palavered1543923palavered
palleted1139873palleted
palter84423263palter__
palterers11249533palterers
palters94021683palter_s
pampered15229233pampered
pandered121812573pandered
papered122513173pa_pered
partnered1244483partnered
pastored1139963pastored
pastured1138233pastured
pattened11299393pattened
patterer103112173patterer
patterned1265743patterned
paupered13216943paupered
pestered112814963pestered
petered103314973_petered
philtred14114183philt_red
pilfered1435853pilfered
plastered1288893plastered
portered112311543portered
pottered112311663pottered
prealtered1344943prealtered
puttered112611143puttered
quartered19155963quartered
rapiered1136053rapiered
raptured1155463raptured
rattened9218623rattened
sabered103213023sa_bered
saggered11237553saggered
salted74121203salt__ed
salter64325083salter__
saltern74010653salter_n
salterns8388903salterns
salters73622253salter_s
saltire73113033saltire_
saltires83112423saltires
sauntered1036283sauntered
sauteed8349613saute_ed
scattered12197353scattered
shatterer12177203shatterer
shelterer1245033shelterer
shuttered13156333shuttered
silvered12237563silvered
sintered92213903sintered
sistered92612803sistered
skeltered1443873skeltered
slathered13148543slathered
slavered12188033slavered
smattered12186783smattered
soldered1038153soldered
spattered12187643spattered
sweltered1344453sweltered
tabered103311593ta_bered
tampered13279463tampered
tapered102612933ta_pered
tautened935423tautened
teetered9258303teetered
telfered1234883telfered
tentered96412103tentered
tillered937443tillered
tittered9239493tittered
tottered9208703tottered
ulcered1037973_ulcered
uttered82712433_uttered
valeted1139013val_eted
valleyed1534013valleyed
wafered14288433wa_fered
wagered12299333wa_gered
walleyed1534153walleyed
waltzed2033493walt_zed
wandered132110793wandered
waterbed1436443wa_terbed
waterer103314073wa_terer
wavered142910433wa_vered
westered122511863westered
wildered1336633wildered
wintered122111573wintered
yabbered1633963yabbered
yammered16225763yammered

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.453394461.4
2DLD Change Limit1461623037.62319173.8
3Display Results3033030.1262404.8
 (SQL Overall)1786913038.20221786.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.