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

92 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
matzoons1910508(None) 
madzoons20124771madzoons
matzoon1896471matzoon_
madzoon1996062madzoon_
maroons92615552ma_roons
matrons93517632mat_rons
matzohs2134372matz_ohs
matzos1749262matz_o_s
patroons102710602patroons
ratoons73815472rat_oons
rattoons8327512rattoons
amazons1836653amaz_ons
attorns738443_attorns
azlons154110423_a_zlons
azons146518253_a_z_ons
baboons113211083ba_boons
balloons103110523balloons
bassoons1036553bassoons
batons85519423bat__ons
bazooms20285383ba_zooms
bazoos173212623ba_zoo_s
cardoons113411943cardoons
cartoons104012803cartoons
cations94524143cat_ions
dahoons1137753da_hoons
eftsoons1142613eftsoons
fatwoods1585953fatwoods
gaboons10289903ga_boons
gadroons1037013gadroons
gadzooks23112933gadzooks
galloons9289703galloons
gazoos163010223ga_zoo_s
harpoons1337483harpoons
jargoons1644663jargoons
kations114013663kat_ions
kazoos19259113ka_zoo_s
lagoons839253la_goons
lampoons12266873lampoons
lardoons9398483lardoons
macaroons1345563macaroons
macons104017243ma__cons
macrons113514893ma_crons
madronos11337543madronos
mahzors2135123mahz_ors
malisons1048783malisons
mammons1048513ma_mmons
manhoods1447243manhoods
mansions1069793mansions
maroon83118203ma_roon_
marrons93216973ma_rrons
martagons1245123martagons
mascons113411583ma_scons
masons83916513ma__sons
mastodons1244123mastodons
matadors1156983matadors
matelots1047533matelots
matins84527783mat__ins
matron83918313mat_ron_
mattins93316143mat_tins
mattocks1644983mattocks
mattoids1196183mattoids
matzahs2134483matz_ahs
matzas1749703matz__as
matzo16312893matz_o__
matzoh2035483matz_o_h
matzot17710983matz_o_t
matzoth2144333matz_oth
metazoans2044473metazoans
metazoon1944053metazoon_
metopons12107023metopons
midnoons1144403midnoons
monsoons1047343monsoons
moons75331003m___oons
motions94215003mot_ions
mutons84314363mut__ons
muttons949283mut_tons
nations74720563nat_ions
natrons73215663nat_rons
patrons93818103pat_rons
patroon92811973patroon_
platoons1038683plat_oons
raccoons1265453raccoons
racoons93912433ra_coons
rations74123433rat_ions
ratoon64417373rat_oon_
rattons73815323rat_tons
rattoon7359243rattoon_
saloons74415323sa_loons
tattoos738643tattoo_s
toons55027533__t_oons
wazoos18288553wa_zoo_s
zoons144919693___zoons

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 Filter1786911461620.453394461.4
2DLD Change Limit146162926.37622923.8
3Display Results92920.0303066.7
 (SQL Overall)178691926.85926052.0
 
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.