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

147 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
inhaul93680(None) 
inhauls1035521inhauls
haul75530452__haul
infall939402infall
inhale9411522inhale
inhauler1163942inhauler
insoul638462insoul
inwall938342inwall
shaul85418102_shaul
anal48037523an_a_l
annal56520763anna_l
annual64710703annual
annul55813383an_nul
binal75323823bin_a_l
boxhaul1943013boxhaul
caul65630003__caul
dhal86719283_dha_l
dishful1455433dishful
downhaul1542883downhaul
enhalo987573enhalo
ensoul638253ensoul
entail61114343entail
final83922033fin_a_l
finial92814183finia_l
ghaut95919433_ghaut
ghoul959053_ghoul
gingal81010153ginga_l
gingall9117333gingall
gnarl65115573gn_arl
hail74839063__hail
hall75741163__hall
hamaul114210873hamaul
harl75740003__harl
haulm104415413__haulm
hauls86123733__hauls
haut75949733__haut
ideal65716393idea_l
ileal56118083ilea_l
ilial55317843ilia_l
imaum9139643i_maum
inane52820343in_ane
inapt73522693in_apt
inarm7314423in_arm
incage93513623incage
incant82418513incant
incase83615283incase
incult82414773in_cult
incur72212253in_cur
incus73315053in_cus
indaba935633indaba
indium939503indium
indol63714873in_dol
indue63516673in_due
indult73614033in_dult
infalls1038943infalls
infamy1435653infamy
infant92315133infant
infare9313083infare
infauna1044403infauna
infaunal1143823infaunal
infill938413infill
influx1643723influx
ingate73018243ingate
ingulf10310353in_gulf
inhabit1277403inhabit
inhaled1169333inhaled
inhaler1068053inhaler
inhales10511863inhales
inhaulers1263243inhaulers
inhere9313713inhere
inhume1196583inhume
inia45024703inia__
inlace82513043inlace
inlaid7310143inlaid
inland7310313inland
inlay85214323inla_y
inlays9389873inlays
inmate82917363inmate
innage73011573innage
innate63917313innate
inocula947273inocula
inphase1245393inphase
inpour837063inpour
input7314653in_put
inrun52911373in_run
insane6314893insane
insculp1143793insculp
insouls737213insouls
instal6712193instal
install779363install
instil61111383instil
insult62813673in_sult
intact8314663intact
intagli845023intagli
intake10510863intake
inthral10249463inthral
inthrall11247063inthrall
invade10157853invade
invar839513inva_r
invars9310003invars
inwalls1037283inwalls
inward10310333inward
ireful948713ireful
jingal1498593jinga_l
jingall1566173jingall
knaur9508253kn_aur
lineal65616033linea_l
lingual8379083lingual
maul64830723__maul
miaul71612123_miaul
mindful1344613mindful
nail45838653_n_ail
nidal65217103nida_l
nihil8410283nih_il
nival84915773niva_l
outhaul1039063outhaul
pinball1137933pinball
pineal84817693pinea_l
pinnal84814283pinna_l
pintail9311183pintail
saul45836523__saul
schul102510413sch_ul
shall85024053_shall
shauls94913113_shauls
shawl116217573_shawl
shul75823153_sh_ul
sinful938803sin_ful
snail57020203sn_ail
snarl54921083sn_arl
tincal83913373tinca_l
tineal66216173tinea_l
tinful938043tin_ful
unau43924153un_au_
unaus53216573un_aus
ungual738183ungual
unhair937333unhair
unhand10410383unhand
unhang1038443unhang
unhat81119263unha_t
unhats91110623unhats
unnail6410583unnail
vinal85725813vin_a_l
vineal94814753vinea_l
waul76927313__waul
whaup13458883_whaup
wishful1664503wishful
withal1238933witha_l

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161475.28021347.7
3Display Results1471470.0463195.7
 (SQL Overall)1786911475.69931354.8
 
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.