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 “halters” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

167 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
halters10461980(None) 
alters64924221_alters
falters103916471falters
hafters134614331hafters
halers94926911hal_ers
halter94420881halter_
haltere103614701haltere
halteres113414591halteres
halvers133311421halvers
haters94930401ha_ters
hatters104221521hatters
palters94021681palters
salters73622251salters
afters94717072_afters
alders74218422_alders
altars64518152_altars
alter54828502_alter_
asters65631602_asters
baiters94619302baiters
balers85626932bal_ers
balkers134915722balkers
ballers94421012ballers
banters94623112banters
barters94223032barters
basters94930302basters
batters94626012batters
belters93819412belters
bolters94017802bolters
calkers134414692calkers
callers94221962callers
canters94827732canters
carters95327252carters
casters94729902casters
caters85336502ca_ters
chanters134016742chanters
chapters154012132chapters
charters134115582charters
chatters134213952chatters
colters93522442colters
darters84017602darters
daters74827372da_ters
easters75125682easters
eaters65535952ea_ters
elaters74420192elaters
exalters1536652exalters
fallers103917992fallers
falter94519052falter_
filters103816552filters
gaiters83516542gaiters
garters84218232garters
gasters85624292gasters
gaters74728642ga_ters
hackers164619042hackers
hafter124815882hafter_
hailers104017262hailers
halberd1336052halberd
halberds1435182halberds
halbert12314502halbert
halberts1335972halberts
haler85033522hal_er_
haleru94212072hal_eru
hales85449842hal_e_s
halites103221192halite_s
hallels103310132hallels
haloes94623862haloe_s
halted105019602halte_d
haltered123112552haltered
haltless11308442haltless
halts85230102halt__s
halves124717092halve_s
hammers144216062hammers
hampers143616952hampers
hamsters13710422hamsters
handers114224332handers
hangers113120812hangers
hankers144218132hankers
haptens124511342haptens
harmers124116592harmers
harpers124916202harpers
hastens106214812hastens
hastes95727072haste_s
hater85034752ha_ter_
hates86742572ha_te_s
hatless103813442hatless
hatter94724872hatter_
haulers104012442haulers
hauliers1176712hauliers
haunters11329542haunters
hauteurs1133732hauteurs
havers124721482ha_vers
hawkers174210332hawkers
hawsers13409482hawsers
hayers124415942ha_yers
hazers184615952ha_zers
healers104319462heal_ers
heaters104225222heaters
hefters134312002hefters
hellers103619832hellers
helpers123311852helpers
hillers103718732hillers
hinters103719582hinters
hitters104717592hitters
holders113715902holders
hollers103818232hollers
holsters113211942holsters
hooters104520472hooters
hullers103616262hullers
hunters103915732hunters
hurters103413642hurters
jilters144211962jilters
jolters143711992jolters
kelters113813752kelters
kilters113813602kilters
lasters75627692lasters
malteds10377602malteds
masters94628922masters
maters85032392ma_ters
matters94421752matters
melters93918312melters
milters93619092milters
molters93816972molters
natters73718062natters
oaters65029792oa_ters
palmers113513622palmers
palter84423262palter_
pasters94531732pasters
paters84935832pa_ters
patters94825192patters
pelters93720312pelters
philters1398172philters
platers93924092platers
psalters10227712psalters
rafters103715632rafters
ranters73323642ranters
rasters74629022rasters
raters63936582ra_ters
ratters74422472ratters
realters83614042realters
salter64325082salter_
saltern74010652saltern
salterns8388902salterns
saltiers83411952saltiers
saluters8319862saluters
salvers103916002salvers
shatters113313912shatters
shelters113412812shelters
slaters73123732slaters
talers64628142tal_ers
talkers113513212talkers
tasters74225642tasters
taters64932202ta_ters
tatters74520482tatters
thalers106212262thal_ers
tilters73315952tilters
valuers10328942valuers
vaulters11206172vaulters
wafters134112812wafters
waiters104218622waiters
walers94824462wal_ers
walkers143411472walkers
waltzers2034002waltzers
wanters104420092wanters
wasters104026592wasters
waters95030632wa_ters
welters103516062welters
whalers13529702whal_ers
yatters103914622yatters

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit1076711673.23633272.9
3Display Results1671670.0602783.3
 (SQL Overall)1786911673.66948702.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.