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

81 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
mangonel118576(None) 
mangonels1294371mangonels
jargonel1643682jargonel
mangel94017532mang__el
mangoes104316132mango_es
agonal7410053_a_gonal
agone65924553_a_gone_
agones75719863_a_gones
anconal939423_anconal
ancone83916953_ancone_
anconeal1045593_anconeal
ancones93116343_ancones
angel65019563_ang__el
anginal8310163_anginal
anyone94612733_anyone_
cannel84216403can__nel
cannoned11118143cannoned
cantonal1038903cantonal
cantoned111411523cantoned
canzone1858813canzone_
canzones1939153canzones
canzonet19410583canzonet
gangrel996143gang_rel
hangover15134433hangover
jargoned1735233jargoned
jargonels1743153jargonels
langrel8107033lang_rel
madrone102812663madrone_
madrones112912283madrones
magnet9320663ma_g_net
mandrel1038683man_drel
mangabey1643463mangabey
manganese1244803manganese
manganic1346993manganic
manganin1147543manganin
mange84930193mang__e_
mangels103614493mang__els
manger94325003mang__er
manges94628943mang__es
mangey123614523mang__ey
mangier104114063mang_ier
manginess122010413manginess
mangle93921323mang_le_
mangled113615263mang_led
mangler103215643mang_ler
mangles104021463mang_les
mango85724323mango___
mangold1137213mango_ld
mangolds1235193mangolds
mangos94319333mango__s
mangrove1474403mangrove_
mangroves1574293mangroves
manhole12311343manhole_
manholes13311183manholes
manned94418643man__ned
manner84020513man__ner
mannose939243mannose_
mannoses1039083mannoses
manpower1544703manpower
manrope1138033manrope_
manropes1237913manropes
mantel84317973man__tel
marginal1137603marginal
margined1237743margined
marooned1138563marooned
masoned1039803ma_soned
matronal1048113matronal
mongoe94214983mongo_e_
mongoes103415713mongo_es
mongol94912533mongo__l
mongrel1036333mong_rel
mungoes103510463mungo_es
pangene102711963pangene_
pangenes112612823pangenes
tangoed9318833tango_ed
waggoned1443253waggoned
waggoner1343423waggoner
wagoned1256223wa_goned
wagoner1136093wa_goner
wantoned12117223wantoned
wantoner1187563wantoner

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 Filter1786911461620.420425454.8
2DLD Change Limit146162817.59619242.0
3Display Results81810.0302700.0
 (SQL Overall)178691818.04622208.7
 
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.