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 “huzzaed” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
huzzaed194310(None) 
huzzahed2341501huzzahed
buzzard1844272buzzard
buzzed17408472buzz_ed
fuzzed18479252fuzz_ed
guzzled17326262guzzled
huzza1646092huzza__
huzzah2044422huzza_h
huzzahs2143082huzzahs
huzzas1735862huzza_s
muzzled18267752muzzled
nuzzled16276392nuzzled
puzzled18286652puzzled
buzzards1943613buzzards
buzzer16379113buzz_er
buzzes165011173buzz_es
dazzled1735033dazzled
dizzied17236133dizzied
fezzed18398243fezz_ed
fizzed18369443fizz_ed
fizzled19357273fizzled
futzed19418983futz_ed
fuzed185415253fu_z_ed
fuzzes175412253fuzz_es
fuzzier18256523fuzzier
gizzard17114203gizzard
guzzle15297913guzzle_
guzzler16286563guzzler
guzzles16328043guzzles
haed86338583h___aed
hazard1938403h_azard
hazed185222203h_az_ed
hazzan17236803hazza_n
hazzans18215783hazzans
heezed194210513heez_ed
hennaed1135103hennaed
hollaed11359853hollaed
huddled13349783huddled
hued86925853hu___ed
huffed163710153hu_ffed
hugged124113643hu_gged
hulked144611303hu_lked
hulled103920013hu_lled
hulloaed12105803hulloaed
hulloed11369793hulloed
humbled153711813humbled
hummed144812673hu_mmed
humored1336723humored
humped144015243hu_mped
humphed1835423humphed
hunched163710493hunched
hundred1237143hundred
hunted104417013hu_nted
hurdled12379833hurdled
hurled104617453hu_rled
hurrahed1543473hurrahed
hurrayed1543053hurrayed
hurried113511043hurried
hurtled11339593hurtled
husband1345653husband
hushed134416673hu_shed
husked144212223hu_sked
hustled113210133hustled
hutched16359883hutched
hutted104616333hu_tted
huzzaing2042433huzzaing
izzard15135243_izzard
jazzed22416293jazz_ed
mazzard1844463mazzard
mizzled18327633mizzled
muzzier17326553muzzier
muzzle16319393muzzle_
muzzler17257943muzzler
muzzles17299683muzzles
nudzhed2141823nudzhed
nuzzle14298083nuzzle_
nuzzler15296493nuzzler
nuzzles15298123nuzzles
putzed18409113putz_ed
puzzle16318603puzzle_
puzzler17276963puzzler
puzzles17318973puzzles
quizzed2534043quizzed
razzed15478283razz_ed
rhumbaed1672753rhumbaed
rumbaed12287493rumbaed
sizzled16367883sizzled
sozzled16265183sozzled
whizzed2234063whizz_ed
zizzled15315853zizzled

Search took 9 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 Filter1786911340270.420425454.8
2DLD Change Limit134027908.28316181.0
3Display Results90900.0461956.5
 (SQL Overall)178691908.74920424.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.