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

166 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
mongrel103633(None) 
mongrels1135331mongrels
doggrel1033882doggrel
gangrel996142gangrel
langrel8107032langrel
mandrel1038682mandrel
mangel94017542mang_el
monger94418332mong_er
mongered1238952mongered
mongers104217272mongers
mongoe94214982mongoe_
mongoes103415712mongoes
mongol94912532mong_ol
mongrelly1542882mongrelly
morel75729092mo__rel
angel65019573_ang_el
bonged105719603bong_ed
bongoes104314113bongoes
congaed11399743congaed
conge85227593cong_e_
congeal104011683congeal
congee96024473cong_ee
congeed113212313congeed
congees103517923congees
conger95024273cong_er
congers104223233congers
conges94928173cong_es
congoes103617303congoes
congress1138073congress
control9310693control
costrel9310373costrel
doggerel1143453doggerel
doggrels1142633doggrels
dongle83612493dongle_
dongles93212873dongles
donzel1636313don_zel
dottrel834463dottrel
fodgel1136413fodg_el
gangrels1094973gangrels
gomerel1036393gomerel
gonged97115913gong_ed
hongied12308163hongied
hongies112716473hongies
honored11310123honored
honoree10412113honoree
honorer1039673honorer
langrels9106173langrels
longe66626463long_e_
longed87121373long_ed
longer75823203long_er
longers84819543longers
longes75925573long_es
longies82916553longies
maigre9309163maigre_
malgre9299303malgre_
mandrels1137313mandrels
mandril1049353mandril
mange84930203mang_e_
mangels103614493mang_els
manger94325013mang_er
mangers103521263mangers
manges94628953mang_es
mangey123614533mang_ey
mangier104114063mangier
mangle93921333mangle_
mangled113615263mangled
mangler103215643mangler
mangles104021463mangles
mangoes104316133mangoes
mangonel1185763mangonel
mantel84317973man_tel
manure8313653manure_
manured1039473manured
manurer938583manurer
manures9313353manures
maugre9308973maugre_
meagre9349323meagre_
meagrely1443013meagrely
minaret9520683minaret
mineral9312743mineral
mingier103815293mingier
mingle93518783mingle_
mingled113612733mingled
mingler104213843mingler
mingles103719003mingles
minored10310103minored
minstrel1046913minstrel
misgrew1335523misgrew
model84521693mo__del
mogged115215393mo_gged
moggie103210103moggie_
moggies113111723moggies
moghul1244473mo_ghul
mogul8310213mo_g_ul
mohel104914833mo__hel
moire71017323mo_ire_
moires8915633mo_ires
monadal1047893monadal
monades103713823monades
monarch1445953monarch
monarda1046613monarda
monaural1046213monaural
monde85723143mon_de_
mondes94322353mon_des
moneran9311113moneran
money104826843mon__ey
moneyed1337493moneyed
moneyer1237903moneyer
mongeese1144593mongeese
mongo810122413mong__o
mongols103310823mongols
mongos94318623mong_os
mongrelize2252623mongrelize
mongst93512603mong_st
monie75631653mon_ie_
monied94319463mon_ied
monies83233163mon_ies
moniker1338673moniker
monkery16317453monkery
monkey153710593mon_key
monocle1139663monocle
monofil1247273monofil
monofuel1344053monofuel
monogerm1345963monogerm
monogram1379183monogram
monomer11311893monomer
monorail1059773monorail
monster93214603monster
monte75829773mon_te_
montero9310133montero
montes84226933mon_tes
monuron937463monuron
moored93814173mo_ored
moral75533433mo__ral
more67154523mo__re_
morels84820023mo__rels
mores76249643mo__res
morgen9312203morg_en
morgue938113morgue_
morgues1038273morgues
morsel85815893mo_rsel
motel76623243mo__tel
motored1039933motored
mungoes103510463mungoes
nonfuel1045733nonfuel
nongreen945513nongreen
nonoral7313603nonoral
ogre56320743_o_gre_
ogres65818633_o_gres
poitrel936193poitrel
ponged105619353pong_ed
pongee94920193pong_ee
pongees104212543pongees
rondel73212643ron_del
ronnel63310893ron_nel
solgel737963solg_el
songful1145173songful
sorel56231443so__rel
sorrel6413553so_rrel
tonged86518913tong_ed
tonger74719693tong_er
tongers84116013tongers
tongmen1037123tongmen
tongue7410103tongue_
tongued946323tongued
tongues879693tongues

Search took 8 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.436409841.7
2DLD Change Limit1340271666.96619240.2
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.46523937.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.