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

311 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
halts8523010(None) 
alts46639901_alts
haets86525121haets
hafts116219461hafts
hales85449841hales
halls85633781halls
halms105225211halms
halos85230251halos
halt76056301halt_
hants86335401hants
harts88441591harts
hats76858251ha_ts
hilts86924411hilts
holts85627911holts
malts76331751malts
salts55431881salts
aals49941142aal_s
acts66929862_acts
aits46355532_aits
alas46358122_alas
albs68628572_albs
ales47067102_ales
alls46740922_alls
alms65834922_alms
alps65529242_alps
als36663022_al_s
alt36467962_alt_
alto47831262_alto
altos55822952_altos
ants47243472_ants
arts49650262_arts
bahts105617802bahts
baits76630582baits
balas76937212balas
balds85524642balds
bales76250082bales
balks114926292balks
balls76236412balls
balms95723922balms
bals66354042bal_s
basts75936932basts
bats66962332ba_ts
batts76727562batts
belts75931162belts
blats75132502blats
bolts76232112bolts
calfs104919382calfs
calks115421602calks
calls75634732calls
calms95222352calms
calos74431902calos
cants77036942cants
carts78946292carts
casts77237792casts
cats66356342ca_ts
celts75325782celts
chalets122813472chalets
chalks155412142chalks
chants115020392chants
charts115823092charts
chats105730092cha_ts
colts76633292colts
cults75022552cults
dales66439742dales
dals57145122dal_s
darts67635732darts
dauts67822242dauts
dawts97216122dawts
delts65731792delts
dhals95415442dhal_s
dolts65626312dolts
easts57530322easts
eats47054872ea_ts
exalts13328312exalts
facts107021892facts
falls85727652falls
farts88336842farts
fasts86429682fasts
fats76252502fa_ts
faults94513552faults
felts85324542felts
flats86429742flats
gaits65726012gaits
galas65731642galas
gales65442482gales
galls64729322galls
gals57946502gal_s
gasts66628632gasts
gats56753442ga_ts
gaults74112782gaults
gelts65924612gelts
ghats95818612gha_ts
ghauts10447782ghauts
gilts64924262gilts
haafs115711162haafs
haars85620472haars
habits113014652habits
habus106317142habus
hacks144928712hacks
hades96035112hades
hadst93220222hadst
haems105517012haems
haes77651022ha_es
haet75659502haet_
haft105941842haft_
hags86740842ha_gs
hahas117118442hahas
hahs108333362ha_hs
haiks125120932haiks
hails85231642hails
haints94417582haints
hairs86225172hairs
hajes155420942hajes
hajis156716282hajis
hakes126034302hakes
hakus125114112hakus
halal85623592halal
halals95018312halals
hale76052832hal_e
haled95335822haled
haler85033522haler
halers94926912halers
halest94823272halest
half106238452hal_f
halid94424982halid
halids104016132halids
halite93624232halite
halites103221192halites
halitus10339962halitus
hall75741162hal_l
hallo85127552hallo
hallos95425102hallos
halm95834972hal_m
halma108219252halma
halmas117017892halmas
halo76437322hal_o
haloes94623862haloes
halon86124862halon
halons95720712halons
halted105019602halted
halter94420882halter
halters104619802halters
halutz1868852halutz
halva115414432halva
halvas124714172halvas
halve114818922halve
halves124717092halves
hames106138702hames
hamlets123211402hamlets
hams96446132ha_ms
hands95327382hands
hangs95726722hangs
hanks126226862hanks
hant75461592hant_
haoles94919802haoles
haps96443462ha_ps
hards96435652hards
hares86255542hares
harks126333432harks
harlots103413292harlots
harls85634502harls
harms106829012harms
harps105926872harps
hart76865772hart_
has67372652ha__s
haslets102510862haslets
hasps105114642hasps
hast76259482hast_
haste85927862haste
hastes95727072hastes
hasty115718762hasty
hat67289962ha_t_
hate78450172ha_te
hates86742572hates
hath105933912ha_th
haulms11558502haulms
hauls86123732hauls
haunts95614392haunts
haut75949732haut_
haute89521612haute
haves116034872haves
hawks155415702hawks
haws106439442ha_ws
hays106138072ha_ys
hazes174928322hazes
heals85733452heal_s
health124712142health
healths13478752healths
hearts96218942hearts
heats85838402heats
hefts116218152hefts
hells85032042hells
helms105619462helms
helos84928062helos
helots95217702helots
helps105219342helps
hents87330742hents
hests85829932hests
hets75547202h_ets
hills85431352hills
hilt75850712hilt_
hilus84817642hilus
hints87330622hints
hists86328372hists
hits75545132h_its
holds94623242holds
holes84748652holes
holks124720562holks
holms105117802holms
hols76946292hol_s
holt77852582holt_
hoots84830252hoots
hosts85526702hosts
hots78349332h_ots
hulas84920882hulas
hulks125715482hulks
hulls84923562hulls
hunts86826172hunts
hurts86922822hurts
huts76737442h_uts
hylas114815902hylas
jilts124717412jilts
jolts125018882jolts
kales95730982kales
karts97630112karts
kats85944332ka_ts
kelts95222632kelts
khats125316012kha_ts
kilts95122182kilts
lalls55324132lalls
lasts57731262lasts
lats45962702la_ts
lilts55822802lilts
males75049792males
malls76233432malls
malms95021552malms
malt66254812malt_
malty106721702malty
marts77442232marts
masts77035762masts
mats65460292ma_ts
matts76829182matts
mauts75927192mauts
melts74930102melts
milts75430712milts
molts76032092molts
nalas55528362nalas
oasts56529182oasts
oats46554212oa_ts
pacts95125802pacts
pales75753802pales
palets85122312palets
palls74332562palls
palms94921752palms
palps94719562palps
pals66951352pal_s
pants76536922pants
parts77743372parts
pasts75936502pasts
pats66460852pa_ts
pelts76128812pelts
plats75531372plats
qats135331342qa_ts
rafts87820632rafts
rales54947492rales
rants55935342rants
rats46260372ra_ts
sales56055592sales
salps74423242salps
sals46851672sal_s
salt45758522salt_
salty85524382salty
saults65816172saults
shafts125411442shafts
shales94731252shales
shalt85534492shalt_
silts55330822silts
slats55436902slats
smalts85214892smalts
tacts76524122tacts
talas55935892talas
talcs74817182talcs
tales55451372tales
talks94322692talks
talls55133432talls
talus55423262talus
tarts57242022tarts
tats46858132ta_ts
tauts56125512tauts
tilts55325612tilts
vales85434262vales
valets93715622valets
vasts86423772vasts
vats76841742va_ts
vaults94511672vaults
volts85421292volts
wafts116920552wafts
waits88333522waits
wales86142832wales
walks126218502walks
walls85529382walls
waltz17615472waltz
wants87932212wants
warts814840402warts
wasts87433672wasts
wats77555882wa_ts
watts86923092watts
welts85225192welts
whales124716942whales
whats117718992wha_ts
wilts85023502wilts

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538003111.59333772.8
3Display Results3113110.0764092.1
 (SQL Overall)1786913111.98290156.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.