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

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

76 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
mangoes10431613(None) 
manges94628941mang_es
mangles104021461mangles
mangos94319331mango_s
mongoes103415711mongoes
mungoes103510461mungoes
angles74426702_angles
bangles103617412bangles
banjoes16317312banjoes
bingoes104013982bingoes
bongoes104314112bongoes
cangues10611822cangues
canoes84725882can_oes
cargoes104415222cargoes
congoes103617302congoes
dagoes85714602da_goes
dangles93618422dangles
dingoes94114832dingoes
fungoes11388812fungoes
gangues9149752gangues
imagoes10126402ima_goes
jangles154015682jangles
jingoes153811442jingoes
langues81211912langues
lingoes84014692lingoes
mages85036022ma_g_es
maggots1136562maggots
magots9312362ma_gots
mahoes11313102ma_hoes
mamboes135011822mamboes
manages103418962manages
manches143818622manches
maneges103612142maneges
manes76648962man__es
mangas94122922mang_as
mange84930192mang_e_
mangel94017532mang_el
mangels103614492mangels
manger94325002mang_er
mangers103521262mangers
mangey123614522mang_ey
mangier104114062mangier
mangiest112815902mangiest
mangle93921322mangle_
mangled113615262mangled
mangler103215642mangler
manglers113311902manglers
mango85724322mango__
mangold1137212mangold
mangolds1235192mangolds
mangonel1185762mangonel
mangonels1294372mangonels
mangroves1574292mangroves
manholes13311182manholes
maniocs113611442maniocs
mannose939242mannose
mannoses1039082mannoses
manors84420882man_ors
manos74933622man_o_s
manropes1237912manropes
manses84225512man_ses
mantes84430782man_tes
mantles94820702mantles
manures9313352manures
marges94525712marg_es
mingles103719002mingles
mongoe94214982mongoe_
mongols103310822mongols
mongos94318622mongo_s
mungos94311372mungo_s
pingoes105116522pingoes
ranges73826922rang_es
tangles83920042tangles
tangoed9318832tangoed
tangos74216302tango_s
wangles113416932wangles

Search took 4 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 Filter1786911076710.403443402.0
2DLD Change Limit107671763.50330736.8
3Display Results76760.0302533.3
 (SQL Overall)178691763.93645399.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.