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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
mongrels113533(None) 
mongrel1036331mongrel_
congress1138072congress
doggrels1142632doggrels
gangrels1094972gangrels
langrels9106172langrels
mandrels1137312mandrels
mangels103614492mang_els
mongers104217272mong_ers
mongoes103415712mongoe_s
mongols103310822mong_ols
mongrelly1542882mongrelly
morels84820012mo__rels
angels74416173_ang_els
bongoes104314113bongoe_s
congeals11309853congeals
congees103517923cong_ees
congers104223233cong_ers
conges94928173cong_e_s
congoes103617303congoe_s
congrats11311433congrats
controls10311393controls
costrels1038933costrels
doggerels1252153doggerels
doggrel1033883doggrel_
dongles93212873dongle_s
donzels1735393don_zels
dottrels963493dottrels
gangrel996143gangrel_
gomerels1144563gomerels
hongies112716473hongie_s
honorees1148773honorees
honorers1139263honorers
ingress838653_ingress
langrel8107033langrel_
longers84819543long_ers
longes75925573long_e_s
longies82916553longie_s
longness938553longness
mandrel1038683mandrel_
mandrils1138493mandrils
mangel94017533mang_el_
mangers103521263mang_ers
manges94628943mang_e_s
manglers113311903manglers
mangles104021463mangle_s
mangoes104316133mangoe_s
mangonels1294373mangonels
mantels94515043man_tels
manurers1037593manurers
manures9313353manure_s
meagrely1443013meagrely
minarets1048843minarets
minerals10311373minerals
minglers113011293minglers
mingles103719003mingle_s
minstrels1145693minstrels
models94216353mo__dels
moggies113111723moggie_s
moghuls1343613mo_ghuls
moguls948553mo_g_uls
mohels115011323mo__hels
moires8915633mo_ire_s
monades103713823monade_s
monarchs1544833monarchs
monardas1145713monardas
mondes94322353mon_de_s
monerans10310343monerans
moneyers1337423moneyers
moneys115513623mon__eys
mongeese1144593mongeese
monger94418333mong_e_r
mongered1238953mongered
mongoe94214983mongoe__
mongol94912533mong_ol_
mongos94318623mong__os
mongrelize2252623mongrelize
mongrelizes2352643mongrelizes
monies83233163mon_ie_s
monikers1437413monikers
monkeys16407423mon_keys
monocles12310673monocles
monofils1346963monofils
monofuels1443243monofuels
monograms1478263monograms
monomers12311033monomers
monorails1148743monorails
monsters103314553monsters
monteros1039453monteros
montes84226933mon_te_s
monurons1037093monurons
morals85324633mo__rals
morel75729093mo__rel_
mores76249643mo__re_s
morgens10310463morg_ens
morgues1038273morgue_s
morsels94112653mo_rsels
motels83616893mo__tels
mungoes103510463mungoe_s
nongreasy1342773nongreasy
nongreen945513nongreen
ogres65818633_o_gre_s
ogress7529503_o_gress
poitrels1035243poitrels
pongees104212543pong_ees
rondels82510053ron_dels
ronnels7318613ron_nels
songless9218823songless
sorels63921163so__rels
sorrels7310723so_rrels
tongers84116013tong_ers
tongues879693tongue_s

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.420425454.8
2DLD Change Limit1461621126.34623032.1
3Display Results1121120.0462434.8
 (SQL Overall)1786911126.81226231.8
 
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.