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

278 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
hawala1236891(None) 
halala94715091halala
hawalas13348351hawalas
cabala103516912cabala
hadal95518122hadal_
halal85623592halal_
halalah13429392halalah
halalas104214082halalas
halals95018312halals
hamada1239922hamada
hamal104623112hamal_
hamals114816822hamals
kabala124011552kabala
kamala12339962kamala
masala8311812masala
qabala17399192qabala
aal39058673_a_al_
aals49941143_a_als
abaca95118043_abaca
abaka114313823_abaka
abaya104413173_abaya
agama85815583_agama
akela9311343_akela
ala312463603___ala
alula5317093_alula
anal48037523_anal_
argala74712673argala
asana5315483_asana
asyla839333_asyla
awa611939673_aw__a
await85524493_await
awake125014783_awake
award97118043_award
aware86420023_aware
awash116613163_awash
away108024223_awa_y
awl67635303_aw_l_
awls75926093_aw_ls
awol75620673_awol_
awols84713523_awols
axal116520493_axal_
azalea1537003_azalea
baal67033113ba_al_
baals76122703ba_als
bacalao1146613bacalao
bacula103112673bacula
balata8614673balata
banal75925993banal_
banana83213413banana
basal75722283basal_
basalt83519583basalt
bawl95326063baw_l_
bawls105719323baw_ls
bharal1138893bharal_
bharals1236733bharals
bwana10310243_bwana
cabal95222153cabal_
cabalas113516003cabalas
cabals104020153cabals
cabana103913563cabana
cabbala1367183cabbala
calla74827073ca_lla
canal75428043canal_
canals84421663canals
canola8313623canola
cantala94114673cantala
canula8312963canula
casaba1079263casaba
casava1157873casava
catalo8314853catalo
catalpa1136503catalpa
catwalk1645323catwalk
cavalla1257883cavalla
chalaza2145733chalaza
challa114014193cha_lla
cicala10310053cicala
coala77521123_coala
dawdle11399503dawdle
facula112912233facula
falbala1235873falbala
fatal84819373fatal_
favela1237033favela
gadwall1244563gadwall
gala55635163__gala
gayal9312713gayal_
gayals1039513gayals
haaf106227733ha_a_f
haafs115711163ha_afs
haar77323493ha_a_r
haars85620473ha_ars
habdalah1742623habdalah
habile11515213habile
hackle154916813hackle
hackly18298733hackly
haemal113811643haemal_
haftara13136093haftara
haggada1353643haggada
haggle113511983haggle
haha107821063h__aha
hahas117118443haha_s
haika125313793ha_ika
hail74839063ha_il_
hails85231643ha_ils
halacha15388003halacha
halakah17517963halakah
halakha17416583halakha
halalahs14367443halalahs
halavah16447023halavah
hale76052833h__ale
half106238453h__alf
hall75741163h__all
hallah124115403hallah
hallal94415563hallal
hallo85127553ha_llo
halloa94918123halloa
halls85633783ha_lls
halm95834973h__alm
halma108219253ha_lma
halo76437323h__alo
halt76056303h__alt
halva115414433ha_lva
hamadas1339673hamadas
hamate113319833hamate
hamaul114210873hamaul
hamauls12387813hamauls
hammada1545093hammada
hammal134512063hammal_
hammals14409223hammals
hamular1236973hamular
hamuli1137063hamuli
hamza19139773ha_mza
handle104219293handle
haniwa1236743haniwa
hansa85416783ha_nsa
hantle94318203hantle
haole84820083ha_ole
hapax1739323hapa_x
haply135915063ha_ply
harass9313943harass
hardly135112833hardly
hariana10310243hariana
harl75740003ha_rl_
harls85634503ha_rls
hartal9415473hartal_
hartals10313023hartals
hassle93711593hassle
hatable121713963hatable
haul75530453ha_ul_
haulm104415413ha_ulm
hauls86123733ha_uls
havdalah1842153havdalah
haw97153273haw___
hawed126025423haw_ed
hawing134322353hawing
hawk145521153haw__k
hawked174712673hawked
hawker164812663hawker
hawkey19507633hawkey
hawkie163810093hawkie
hawks155415703haw_ks
haws106439443haw__s
hawse116015123haw_se
hawser125910843hawser
hawses125113993hawses
hayward1736413hayward
hazan173813613haza_n
hazans183411653hazans
hazard1938403hazard
hazel176414813hazel_
hazels185710083hazels
hazily2179063hazily
heal75645693h_eal_
heals85733453h_eals
hemal104419803hemal_
herald10311343herald
hewable15177823hewable
hexapla1943343hexapla
hiatal9310203hiatal_
hila76228353h__ila
holla84918493h_olla
hoopla1147633hoopla
horal86328683horal_
howl107625693how_l_
howls116219223how_ls
hula74923753h__ula
hwan105716893h_wa_n
hyla106716513h__yla
impala10256933impala
inwall938343inwall
jacal14313703jacal_
jacals1539873jacals
jacana1537933jacana
jawan15710383jawa_n
jawans1657843jawans
jaywalk2442523jaywalk
kabaka11348503kabaka
kabalas133911063kabalas
kabaya15387123kabaya
kabbala1584613kabbala
kamalas13339123kamalas
kanaka9357523kanaka
koala95112213_koala
labara83712893labara
macula103013673macula
manana84816073manana
mandala10310213mandala
manila84518303manila
maraca10314153maraca
marsala939583marsala
masalas9312053masalas
nagana748943nagana
nala46930393__nala
napalm1047263napalm
narwal938943narwal_
narwals1036983narwals
nasal56217593nasal_
nasals63312463nasals
natal53921493natal_
naval85315833naval_
nawab10810923nawa_b
nawabs1185063nawabs
nyala836823_nyala
paella8410913paella
pajama17317653pajama
palapa10310673palapa
panada94113053panada
panama104213353panama
papal95820673papal_
papaya1337503papaya
papula103011113papula
pataca10311193pataca
pawl95123263paw_l_
pawls105617663paw_ls
payola11208113payola
qabalah21285033qabalah
qabalas18289503qabalas
radula749313radula
ramada9310183ramada
ramal74622243ramal_
rambla103510933rambla
ranula6311813ranula
ratal55025113ratal_
ratals64219583ratals
rawly115115833raw_ly
sabal75422483sabal_
sabals84618863sabals
salal55425703salal_
salals65120083salals
samara8313853samara
satara6315533satara
sawfly1535133sawfly
seawall1046203seawall
shawl116217573shaw_l_
shawls125411973shaw_ls
swale85221593_swale
tabla73318363ta_bla
tala45938053__tala
tamal73522623tamal_
tamale83717403tamale
tamals84116633tamals
tambala1138023tambala
tampala1136613tampala
tapalo839793tapalo
tarama8412733tarama
vagal94613633vagal_
vasal85516293vasal_
vaward13498723vaward
wale74546433__wale
walk115625613__walk
wall76236103__wall
walla85321033wa_lla
waly105830903__waly
wawl105321943waw_l_
wawls115416473waw_ls
yamalka1652963yamalka
yawl104918973yaw_l_
yawls114613603yaw_ls
zanana153810363zanana

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.1401276364.3
2DLD Change Limit1127162785.15621861.1
3Display Results2782780.0763657.9
 (SQL Overall)1786912785.37233263.4
 
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.