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

214 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
hauls8612373(None) 
cauls75727771cauls
hails85231641hails
halls85633781halls
harls85634501harls
haul75530451haul_
haulm104415411haulm
haulms11558501haulms
mauls76524951mauls
sauls55128121sauls
shauls94913111shauls
wauls86120551wauls
aals49941142_aals
ahull84010312ahull
ails45654712_ails
alls46740922_alls
als36663022_a_ls
auks85525262_auks
auld54125362_auld
awls75926092_awls
baals76122702baals
babuls105413642babuls
bails75933522bails
balls76236412balls
bals66354042ba_ls
bauds85821042bauds
baulk114914332baulk
baulks12429372baulks
bawls105719322bawls
calls75634732calls
carls77037422carls
caul65630002caul_
cauld85318442cauld
caulds95512382caulds
caules85927252caules
caulis85320072caulis
caulk115315452caulk
caulks125611862caulks
dahls95012282dahls
dals57145122da_ls
daubs85014562daubs
dauts67822242dauts
dhals95415442dha_ls
duals65620082duals
earls56127512earls
fails85631482fails
falls85727652falls
farls85731112farls
fauld95214492fauld
faulds10438962faulds
fault85428312fault
faults94513552faults
fauns84516752fauns
fouls87221432fouls
galls64729322galls
gals57946502ga_ls
gaols66717572gaols
gauds75717722gauds
gault65128482gault
gaults74112782gaults
gaums86217072gaums
gaurs66317992gaurs
gauss65613452gauss
ghauts10447782ghauts
ghouls1036042ghouls
guls55930852_guls
haafs115711162haafs
haars85620472haars
habus106317142habus
hacks144928712hacks
hades96035112hades
haems105517012haems
haes77651022ha_es
haets86525122haets
hafts116219462hafts
hags86740842ha_gs
hahas117118442hahas
hahs108333362ha_hs
haiks125120932haiks
hail74839062hail_
hairs86225172hairs
hajes155420942hajes
hajis156716272hajis
hakes126034302hakes
hakus125114112hakus
halals95018312halals
hale76052832ha_le
hales85449842hales
half106238452ha_lf
hall75741162ha_ll
hallo85127552hallo
hallos95425102hallos
halm95834972ha_lm
halms105225212halms
halo76437322ha_lo
halos85230252halos
halt76056302ha_lt
halts85230102halts
hamals114816812hamals
hamauls12387802hamauls
hames106138702hames
hams96446132ha_ms
hamuli1137052hamuli
hamulus1235322hamulus
hands95327382hands
hangs95726722hangs
hanks126226862hanks
hants86335402hants
haole84820082haole
haoles94919802haoles
haply135915062haply
haps96443462ha_ps
hards96435652hards
hares86255542hares
harks126333432harks
harl75740002harl_
harms106829012harms
harps105926862harps
harts88441592harts
has67372652ha__s
hasps105114642hasps
hates86742572hates
hatfuls1386022hatfuls
hats76858252ha_ts
haugh125114052haugh
haughs13408562haughs
hauled104415212hauled
hauler95015122hauler
haulers104012442haulers
haulmy14455552haulmy
haunt85229132haunt
haunts95614392haunts
haut75949732hau_t
haute89521612haute
haves116034872haves
hawks155415702hawks
haws106439442ha_ws
hays106138072ha_ys
hazels185710082hazels
hazes174928322hazes
heals85733452heals
heels85625532heels
heils85222192heils
hells85032042hells
herls85226432herls
hills85431352hills
hilus84817642hilus
hols76946292h_ols
hours85422382hours
howls116219222howls
hubs96027142h_ubs
hues75235232h_ues
hugs86129752h_ugs
hula74923752h_ula
hulas84920882h_ulas
hulk115321612h_ulk
hulks125715482h_ulks
hull75428782h_ull
hulls84923562hulls
hums96831422h_ums
huns76136932h_uns
hurls86522712hurls
huts76737442h_uts
inhauls1035512inhauls
jails125422942jails
jarls126120962jarls
jauks165412462jauks
jaups144810532jaups
kails95525212kails
lalls55324132lalls
lauds65618482lauds
mails76037782mails
malls76233432malls
marls75535162marls
mauds85519272mauds
maul64830712maul_
mauts75927192mauts
miauls8178712miauls
nails55730402nails
pails75833062pails
palls74332562palls
pals66951352pa_ls
pawls105617662pawls
puls65437562_puls
rails55937402rails
sails55738102sails
sals46851672sa_ls
saul45836522saul_
sault55834962sault
saults65816172saults
shaul85418102shaul_
shawls125411972shawls
shuls85319712shuls
souls55127362souls
taels56822072taels
tails55634192tails
talls55133432talls
talus55423262talus
taus46342732tau_s
tauts56125512tauts
vails85825932vails
vault85823762vault
vaults94511672vaults
vaus75928922vau_s
wails86631482wails
walls85529382walls
wauks125515162wauks
waul76927312waul_
wawls115416472wawls
whaups14405752whaups
yauds95013222yauds
yauld95511182yauld
yaups105910742yaups
yawls114613602yawls

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.0901985455.6
2DLD Change Limit538002141.86028924.7
3Display Results2142140.0633396.8
 (SQL Overall)1786912142.01388768.5
 
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.