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

212 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
huzzas173586(None) 
huzza1646091huzza_
huzzah2044421huzzah
huzzahs2143081huzzahs
buzzes165011172buzzes
fuzzes175412252fuzzes
hamzas20119012hamzas
hazzan17236802hazzan
hazzans18215782hazzans
hulas84920882hu_las
hutzpas2142692hutzpas
huzzaed1943102huzzaed
pizzas1646982pizzas
tazzas1436272tazzas
auras55932553au_ras
baizas173810823baizas
bizzes163910843bizzes
brazas175812433brazas
bubbas94110703bubbas
bunas75126573bu_nas
bunyas11359433bunyas
buras74736293bu_ras
burkas124513803burkas
burqas174410903burqas
bursas85318273bursas
buzz146617803buzz__
buzzard1844273buzzard
buzzards1943613buzzards
buzzed17408473buzzed
buzzer16379113buzzer
buzzers17347173buzzers
chazzan20204853chazzan
chazzans21234503chazzans
chufas14397673chu_fas
chukkas1532783chukkas
chuppas1644123chuppas
chutzpas2451963chutzpas
colzas174010503colzas
cozzes164510893cozzes
cuppas12458593cuppas
cutlas8313093cutlas
dhurnas1153443dhurnas
dulias71212743dulias
dumas85420433du_mas
duras65727723du_ras
durras74713373durras
fezzes174910403fezzes
fizzes174512553fizzes
furzes186613693furzes
futzes184313113futzes
fuzees184910753fuzees
fuzes175120223fu_zes
fuzils18407963fuzils
fuzz158420573fuzz__
fuzzed18479253fuzzed
fuzzy1929814513fuzz_y
guavas1037153guavas
gummas114810513gummas
guzzle15297913guzzle
guzzles16328043guzzles
gyozas1933603gyozas
hahas117118443h_ahas
halmas117017893halmas
halvas124714173halvas
hamza19139773hamza_
hamzah23135553hamzah
hamzahs24134373hamzahs
hansas94616043hansas
has67372653h___as
hazan173813613h_azan
hazans183411653hazans
hazels185710083hazels
hazers184615953hazers
hazes174928323h_azes
hazmat20312263hazmat
hazmats2136603hazmats
heezes184211643heezes
hennas94211803hennas
hijras1635773hijras
hollas94616903hollas
hondas10313353hondas
hookas135312493hookas
horas86333093h_oras
hostas94515823hostas
hoyas115016163h_oyas
hubcap1553993hubcap
hubcaps1643543hubcaps
hubris11218973hubris
hubs96027143hu__bs
hucks144322173hu_cks
hues75235233hu__es
huffs144514743hu_ffs
hugs86129753hu__gs
hula74923753hu_la_
hulks125715483hu_lks
hulloas103911913hulloas
hullos94916293hullos
hulls84923563hu_lls
human102716033hu_man
humans112312433humans
hummus1336243hummus
humors11129633humors
humphs16528163humphs
humps126322803hu_mps
hums96831423hu__ms
humus106215073hu_mus
hunks125321453hu_nks
huns76136933hu__ns
hunts86826173hu_nts
huppah1644183huppah
huppahs1743333huppahs
hurds95219073hu_rds
hurls86522713hu_rls
hurrah12369183hurrah
hurrahs13336773hurrahs
hurray12459913hurray
hurrays13386153hurrays
hursts97213093hursts
hurts86922823hu_rts
hushes124718593hushes
husks125015453hu_sks
hussar9317283hussar
hussars10326973hussars
huts76737443hu__ts
hutzpa2052803hutzpa
hutzpah2441803hutzpah
hutzpahs2541443hutzpahs
huzzahed2341503huzzahed
huzzaing2042433huzzaing
hydras13239313hydras
hyenas1288953hyenas
hylas114815903h_ylas
jazzes21347883jazzes
jubas144614223ju_bas
judas134911883ju_das
juntas134210503juntas
kudzus20443953kudzus
kurtas10349883kurtas
lezzes14387833lezzes
luffas12337483luffas
lumas75622913lu_mas
lunas55025013lu_nas
lutzes153711923lutzes
matzas1749703matzas
mezuzas1743233mezuzas
mezzos1635043mezzos
mirzas1738173mirzas
mudras94212253mudras
mullas84215933mullas
muras75329563mu_ras
murras84916003murras
muzzle16319393muzzle
muzzles17299683muzzles
muzzy188410603muzz_y
nubias8310083nubias
nuzzle14298083nuzzle
nuzzles15298123nuzzles
outgas7313203outgas
ouzels15408703ouzels
ouzos143210413ou_zos
piazzas1743643piazzas
pizza1538183pizza_
pizzaz1565443pizzaz
plazas17409913plazas
pujas145513323pu_jas
pumas95121563pu_mas
punas74826753pu_nas
punkas123410673punkas
pupas95219283pu_pas
purdas92612263purdas
putzes174212523putzes
puzzle16318603puzzle
puzzles17318973puzzles
quezal2435143quezal
quezals2544253quezals
quizzes2435573quizzes
quotas15339433quotas
razzes144910063razzes
rhumbas14305163rhumbas
ruanas6311263ruanas
rumbas102512013rumbas
scuzzes1734403scuzzes
subas74724073su_bas
sulfas9311563sulfas
summas104313163summas
sunnas63914563sunnas
suras55336323su_ras
surras65919533surras
sutras64818583sutras
suttas63813793suttas
tazza1338083tazza_
thujas1634433thu_jas
thulias1035743thulias
thuyas1234773thu_yas
tubas75119573tu_bas
tufas85314383tu_fas
tunas54224123tu_nas
ulnas55716533_ulnas
ulvas84511503_ulvas
upas68322383_u_pas
ureas55826013_ureas
utas45924953_u_tas
uveas84912283_uveas
vulvas12388843vulvas
whizzes2134713whizzes
wizzes175110773wizzes
yucas106013913yu_cas
yuccas13426553yuccas
yugas95012063yu_gas
yutzes18408413yutzes
zanzas1487053zanzas
zas126946833___zas

Search took 8 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 Limit1127162127.32615385.7
3Display Results2122120.0633365.1
 (SQL Overall)1786912127.52923733.7
 
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.