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

69 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
huzzahs214308(None) 
huzzah2044421huzzah_
huzzas1735861huzza_s
hamzahs24134372hamzahs
hazzans18215782hazzans
huppahs1743332huppahs
hurrahs13336772hurrahs
hutzpahs2541442hutzpahs
huzza1646092huzza__
huzzaed1943102huzzaed
huzzahed2341502huzzahed
buzzard1844273buzzard
buzzards1943613buzzards
buzzers17347173buzzers
buzzes165011173buzz_es
chazzans21234503chazzans
chuddahs18222583chuddahs
chuppahs2042073chuppahs
chutzpahs2851093chutzpahs
fuzzes175412253fuzz_es
guzzles16328043guzzles
hahs108333363h___ahs
hallahs133912463hallahs
halvahs16417533halvahs
hamzah23135563hamzah_
hamzas20119013hamza_s
hazans183411653h_azans
hazmats2136603hazmats
hazzan17236803hazza_n
hijrahs2043443hijrahs
hookahs17446653hookahs
hoorahs13399603hoorahs
horahs126313873h_orahs
houdahs1434243houdahs
howdahs1733613howdahs
hubcaps1643543hubcaps
hulas84920883hu_la_s
humans112312433hu_mans
humphs16528163hu_mphs
huppah1644183huppah_
hurrah12369183hurrah_
hurrays13386153hurrays
hussars10326983hussars
hutzpah2441803hutzpah_
hutzpas2142693hutzpas
huzzahing2441113huzzahing
huzzaing2042433huzzaing
jubbahs2143623jubbahs
jubhahs2242353jubhahs
matzahs2134483matzahs
mezuzahs2141353mezuzahs
mullahs12388733mullahs
muzzles17299683muzzles
nullahs10316993nullahs
nuzzles15298123nuzzles
pizzas1646983pizza_s
pujahs18404943pu_jahs
punkahs16284783punkahs
purdahs13285483purdahs
puzzles17318973puzzles
quezals2544253quezals
rupiahs1253333rupiahs
subahs114512383su_bahs
succahs1435323succahs
sukkahs1382703sukkahs
sunnahs10326593sunnahs
surahs94515543su_rahs
tazzas1436283tazza_s
tussahs10335113tussahs

Search took 7 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.406440125.6
2DLD Change Limit134027695.62323835.5
3Display Results69690.0164312.5
 (SQL Overall)178691696.04529560.1
 
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.