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

265 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
huzza164609(None) 
huzzah2044421huzzah
huzzas1735861huzzas
buzz146617802buzz_
fuzz158420572fuzz_
fuzzy1929814512fuzzy
hamza19139772hamza
hazzan17236802hazzan
hula74923752hu_la
hutzpa2052802hutzpa
huzzaed1943102huzzaed
huzzahs2143082huzzahs
muzzy188410602muzzy
pizza1538182pizza
tazza1338082tazza
abuzz15517213abuzz_
aura45836253au_ra
baiza164813223baiza
braza165214253braza
bubba84311793bubba
bulla74620563bulla
buna64730723bu_na
bunya103810093bunya
bura66139533bu_ra
burka114617693burka
burqa165013093burqa
bursa74921523bursa
buzzard1844273buzzard
buzzed17408473buzzed
buzzer16379113buzzer
buzzes165011173buzzes
chazzan20204853chazzan
chufa13489113chu_fa
chukka1433013chukka
chuppa1543973chuppa
chutzpa2361763chutzpa
colza165112983colza
culpa93610963culpa
cuppa11398523cuppa
curia74523763curia
dhurna1043563dhurna
dizzy177410853dizzy
dulia61014983dulia
duma75524453du_ma
dumka12438833dumka
dura55232113du_ra
durra65315793durra
fezzy199811453fezzy
fizz157519823fizz_
fizzy199015083fizzy
furze176815813furze
furzy2010116063furzy
futz167823803futz_
fuze166422373fu_ze
fuzed185415253fuzed
fuzee175718883fuzee
fuzes175120223fuzes
fuzil173810703fuzil
fuzzed18479253fuzzed
fuzzes175412253fuzzes
guava938583guava
gumma105313103gumma
gutta64613383gutta
guzzle15297913guzzle
gyoza1836113gyoza
ha510259943h___a
haha107821063h_aha
haika125313793haika
halma108219253halma
halva115414433halva
hamzah23135553hamzah
hamzas20119013hamzas
hansa85416783hansa
hazan173813613hazan
haze164833393h_aze
hazed185222203hazed
hazel176414813hazel
hazer174820233hazer
hazes174928323hazes
hazmat20312263hazmat
hazy1918119193h_azy
hazzans18215783hazzans
heeze175313483heeze
henna84414043henna
herma105318883herma
hijra1535643hijra
hila76228353h_ila
holla84918493holla
honda9414983honda
hooka125513903hooka
hora76136553h_ora
hosta85917833hosta
hoya107418373h_oya
hub86437483hu__b
hubby155011393hubby
hubcap1553993hubcap
hubs96027143hu_bs
huck135927633hu_ck
hucks144322173hucks
hue66642303hu__e
hued86925853hu_ed
hues75235233hu_es
huff135623843hu_ff
huffs144514743huffs
huffy174810233huffy
hug76037363hu__g
huge86321653hu_ge
huger94914873huger
hugs86129753hu_gs
huh96432013hu__h
huic94818053hu_ic
hulas84920883hulas
hulk115321613hu_lk
hulks125715483hulks
hulky155312473hulky
hull75428783hu_ll
hullo84417453hullo
hulloa95011183hulloa
hulls84923563hulls
hum85542933hu__m
human102716033human
humic124113243humic
humid114213763humid
humor101110513humor
hump116228723hu_mp
humph155712213humph
humps126322803humps
humpy155115673humpy
hums96831423hu_ms
humus106215073humus
hun65844713hu__n
hunch136416213hunch
hung86126353hu_ng
hunh106323733hu_nh
hunk116029543hu_nk
hunks125321453hunks
hunky155417733hunky
huns76136933hu_ns
hunt76445493hu_nt
hunts86826173hunts
hup86437813hu__p
huppah1644183huppah
hurds95219073hurds
hurl76029933hu_rl
hurls86522713hurls
hurly115819293hurly
hurrah12369183hurrah
hurray12459913hurray
hurry114917183hurry
hurst85527193hurst
hurt77142573hu_rt
hurts86922823hurts
hush105224113hu_sh
husk116021953hu_sk
husks125015453husks
husky156112563husky
hussar9317283hussar
hussy116812763hussy
hut66457293hu__t
hutch135414093hutch
huts76737443hu_ts
hutzpah2441803hutzpah
hutzpas2142693hutzpas
huzzahed2341503huzzahed
huzzaing2042433huzzaing
hydra12249223hydra
hyena11810253hyena
hyla106716513h_yla
hypha1637383hypha
jazz193714463jazz_
jazzy23396363jazzy
juba134916983ju_ba
juga126417323ju_ga
junta123713673junta
jura116024893ju_ra
kudzu19495783kudzu
kuna85120703ku_na
kurta95113913kurta
lezzy16608083lezzy
luffa11409023luffa
luma65527523lu_ma
luna46229853lu_na
lutea54819073lutea
lutz136826323lutz_
matza16311813matza
mezuza1643533mezuza
mezzo1537433mezzo
mirza16410443mirza
mudra83912433mudra
mulla74317113mulla
mura65633293mu_ra
murra74519083murra
musca9311763musca
muzzle16319393muzzle
nubia7311223nubia
nucha10229793nucha
nudzh1835133nudzh
nuzzle14298083nuzzle
ouzel144612323ouzel
ouzo133516933ou_zo
ouzos143210413ouzos
piazza1643823piazza
pizzas1646983pizzas
pizzaz1565443pizzaz
plaza164311063plaza
pucka133412803pucka
puja135714923pu_ja
pukka10457133pukka
pula65129373pu_la
puma85424123pu_ma
puna65331653pu_na
punka114515483punka
pupa85422813pu_pa
purda82914693purda
putz158326323putz_
puzzle16318603puzzle
qua124821973qu__a
quezal2435143quezal
quiz224920003quiz_
quota145111963quota
razz125219423razz_
rhumba13375553rhumba
ruana5312423ruana
ruga56121233ru_ga
rumba93612513rumba
scuzz1537573scuzz_
scuzzy1933083scuzzy
suba64926603su_ba
sulfa8313923sulfa
summa94713313summa
sunna55016063sunna
supra73614253supra
sura45740293su_ra
surra55521343surra
sutra54217933sutra
sutta54015333sutta
tazzas1436273tazzas
tazze1339573tazze
thuja1535213thu_ja
thulia936113thulia
thuya1135583thu_ya
tizzy16548893tizzy
tuba65422363tu_ba
tufa75016613tu_fa
tuna45127843tu_na
ulna46317323_ulna
ulva75412693_ulva
urea46528053_urea
ursa44116903_ursa
uta37425583_u_ta
uvea74712653_uvea
vulva11448803vulva
whizz194210323whizz_
whizzy23274073whizzy
yuca95716723yu_ca
yucca12467443yucca
yuga85615423yu_ga
yurta86014253yurta
yutz167519883yutz_
za1114939203___za
zanza1378703zanza
zoa128529993__zoa
zuz1110622033zu_z_
zuzim1534863zuzim
zzz1017911913__zzz

Search took 5 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 Filter178691836670.1101624463.6
2DLD Change Limit836672654.75017614.1
3Display Results2652650.0803312.5
 (SQL Overall)1786912654.94036172.3
 
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.