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

276 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
mongols10331082(None) 
mongoes103415711mongoes
mongol94912531mongol_
mongos94318621mongo_s
bongoes104314112bongoes
bongos95316652bongo_s
congoes103617302congoes
congos94219882congo_s
congous103615082congous
consols92914072consols
dongola945472dongola
dongolas1045342dongolas
googols935482googols
mangels103614492mangels
mangoes104316132mangoes
mangold1137202mangold
mangolds1235192mangolds
mangos94319332mango_s
moguls948552mo_guls
mondos95217332mondo_s
mongers104217272mongers
mongo810122412mongo__
mongoe94214982mongo_e
mongolism1444662mongolism
mongoose1175352mongoose
mongrels1135332mongrels
monos75930862mon_o_s
mools76027172mo__ols
mungoes103510462mungoes
mungos94311372mungo_s
angels74416173_angels
anglos74413903_anglos
argols74514613_argols
benzols1836673benzols
bingoes104013983bingoes
bingos95514793bingo_s
bonbons1139333bonbons
bongo85720943bongo__
bongoist1147643bongoist
bongs87828423bong__s
borneols1046343borneols
cineols9128853cineols
cogons96818113co_gons
condoes104319203condoes
condole102914953condole
condoles113015803condoles
condoms124214083condoms
condors104018553condors
condos94322333condo_s
congas94417033cong_as
congeals11309853congeals
congees103517923congees
congers104223233congers
conges94928173cong_es
congius103210073congius
congo85623133congo__
congou94313243congo_u
consol82614113consol_
console92715983console
consoles103216153consoles
consuls92412313consuls
contos84923233conto_s
controls10311393controls
convoys15267023convoys
cools75632633co__ols
dingoes94114833dingoes
dongas84914613dong_as
dongle83612493dong_le
dongles93212873dongles
dongs76525813dong__s
donjons1536733donjons
donors75115793don_ors
donzels1735393donzels
drongos935493drongo_s
enols54718403_en_ols
enrols61213383_enrols
fools86824203fo__ols
forgoes11311353forgoes
formols12299413formols
fungals11276783fungals
fungoes11388813fungoes
fungous11367433fungous
gingals9109303gingals
gogos77516523go_go_s
gondola946663gondola
gondolas1046193gondolas
gongs74921613gong__s
gonofs10459863gon_ofs
googol835843googol_
gorgons938853gorgons
hongies112716473hongies
hongs95126203hong__s
honors94816793hon_ors
humongous1543083humongous
indols74714203_indols
ingots7912063_ingots
jingals1588063jingals
jingoes153811443jingoes
lingoes84014693lingoes
lintols7339553lintols
logons79818173lo_gons
logos67225333lo_go_s
longans84510813longans
longbows1443883longbows
longers84819543longers
longes75925573long_es
longies82916553longies
longly10279603long_ly
longs65527063long__s
maggots1136553maggots
magots9312363m_agots
maltols939403maltols
mandola1039023mandola
mandolas1139133mandolas
mangas94122923mang_as
mangel94017533mangel_
mangers103521263mangers
manges94628943mang_es
mangily1339753mangily
mangle93921323mang_le
mangles104021463mangles
mango85724313mango__
mangonels1294373mangonels
manhole12311343manhole
manholes13311183manholes
maniocs113611443maniocs
manors84420883man_ors
manos74933613man_o_s
mantels94515043mantels
manuals9311213manuals
menfolk1643883menfolk
menfolks1742903menfolks
menials94015683menials
menthols1347033menthols
mentors9314993mentors
metols84115773m_etols
mignons1037863mignons
mingle93518783ming_le
mingles103719003mingles
minions93314623minions
minnows1234913minnows
minors85117093min_ors
modals93914443mo_dals
models94216353mo_dels
modioli1045473modioli
modiolus1143773modiolus
moggies113111723moggies
moghuls1343613moghuls
mogs75439333mo_g__s
mogul8310213mo_gul_
mohels115011323mo_hels
moils76125753mo__ils
mojoes15399523mo_joes
mojos145314463mo_jo_s
molls75129783mo__lls
mols65948573m___ols
monades103713823monades
monads94515303mon_ads
monas74732153mon__as
monaxons1744813monaxons
mondes94322353mon_des
mondo85721233mondo__
moneys115513623mon_eys
mongeese1144593mongeese
monger94418333mong_er
mongolian1244483mongolian
mongolisms1544043mongolisms
mongoloid1344403mongoloid
mongoloids1453003mongoloids
mongooses1285603mongooses
mongrel1036333mongrel
mongst93512603mong_st
monies83233163mon_ies
monisms113512803monisms
monists93614783monists
monitors10310813monitors
monkeys16407423monkeys
monks116123393mon__ks
mono66036713mon_o__
monocle1139663monocle
monocles12310673monocles
monocots1249813monocots
monody1238243mon_ody
monofils1346963monofils
monoglot1146843monoglot
monoglots1245373monoglots
monolog10259353mon_olog
monologs112210533monologs
monopods1347973monopods
monopole1249283monopole
monopoles1349573monopoles
monopoly1546823monopoly
mons68152253mon___s
monsoon938493monsoon
monsoons1047343monsoons
montes84226933mon_tes
monthly1535673monthly
months113812933mon_ths
monurons1037093monurons
moods85224623mo__ods
mool67533863mo__ol_
moola75117033mo__ola
moolas83615593mo__olas
moonbows1543953moonbows
moons75331003mo__ons
moors74923143mo__ors
moos66051303mo__o_s
moots75831663mo__ots
morals85324633mo_rals
morels84820013mo_rels
morgans10310123morgans
morgens10310463morgens
morgues1038273morgues
morions94014633morions
morons84919543mo_rons
morros83714673morro_s
morrows12318723morrows
morsels94112653morsels
mortals93914003mortals
motels83616893mo_tels
motions94215003motions
motmots1166133motmots
motors84616593mo_tors
mottoes93412193mottoes
mottos84615243motto_s
moutons9410313moutons
moviola1244823moviola
moviolas1344513moviolas
mozos165516333mo_zo_s
mungo84916053mungo__
mungoose1153223mungoose
nonagons947223nonagons
noncola948293noncola
noncolas1048613noncolas
noncoms1139183noncoms
nonegos837143nonego_s
nongays11176533nongays
nonyls957853non_yls
obols73715863_o_bols
onions64016433_onions
onos46229003_on_o_s
osmols8137313_osmols
pengos94612413pengo_s
pingoes105116523pingoes
pingos95317673pingo_s
podsols1056513podsols
podzols1934683podzols
polyols1238493polyols
pongees104212543pongees
pongids11347413pongids
pongs85526343pong__s
pontils9312213pontils
pontons93315553pontons
pools74427703po__ols
rondels82510053rondels
rondos74616723rondo_s
ronions73313343ronions
ronnels7318613ronnels
ronyons10258433ronyons
santols73513323santols
snools65715873_snools
sokols10399083so_kols
songs67725553song__s
sorgos74514663sorgo_s
sotols63714453so_tols
tangos74216303tango_s
toluols735823toluols
tondos75115913tondo_s
tongas74315513tong_as
tongers84116013tongers
tongs65928463tong__s
tongues879693tongues
tonsils7310183tonsils
tools55325243to__ols
wontons103310533wontons
wools84421463wo__ols

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 Filter1786911340270.1601116818.8
2DLD Change Limit1340272766.67020094.0
3Display Results2762760.0932967.7
 (SQL Overall)1786912766.92325811.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.