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

164 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
motmots116613(None) 
motmot10311071motmot_
marmots11311512marmots
moots75831662mo__ots
motets84216192mot_ets
motions94215002motions
motors84616592mot_ors
mottoes93412192mottoes
mottos84615242motto_s
motts76527002mot__ts
aftmost1244973aftmost
amotions1069843amotions
boots75837973bo__ots
bottoms1136983bottoms
botts75224863bot__ts
bowpots1446023bowpots
coempts1335683coempts
comets105823583co_mets
commits133812373commits
commons13311043commons
comous10816503co_mous
compts125216653co_mpts
coots75636843co__ots
coplots11511593coplots
cormous11312353cormous
cosmos10311753cosmo_s
cottons9312193cottons
dogtrots1044693dogtrots
emotions10610283emotions
folkmots1783603folkmots
foots85528283fo__ots
formats123113573formats
formols12299413formols
foxtrots1843923foxtrots
gemots93712153_gemots
hommos13128503hommo_s
homos105921783ho_mo_s
hoots84830243ho__ots
hotdogs1234453hotdogs
hotfoots1444323hotfoots
hotrods1148283hotrods
hotshots1455513hotshots
hotspots1344833hotspots
kotos95717693kot_o_s
kotows13446513kot_ows
loots55431423lo__ots
lotions74614763lotions
lotos54724633lot_o_s
lottos64613103lotto_s
maggots1136553maggots
magots9312363m_agots
mammets103911113mammets
mammons1048513mammons
mammoth1344983mammoth
mammoths1442853mammoths
marmot10318743marmot_
mascots113910343mascots
matelots1047533matelots
matrons93517633matrons
matts76829183mat__ts
matzohs2134373matzohs
matzos1749263matzo_s
matzot17710983matzot_
matzoth2144333matzoth
maumets11369693maumets
memos95719113m_emo_s
merlots92710123merlots
meteors94610013meteors
methods1338883methods
metols84115773met_ols
metros84217803metro_s
midmost1246153midmost
midmosts1343773midmosts
mitts75523753mit__ts
moats75827643mo__ats
mojoes15399523mo_joes
mojos145314463mo_jo_s
molests93311563molests
molts76032093mo__lts
moments113113123moments
momes95134473mo_m_es
mommas94110653mo_mmas
mommies103912273mommies
moms86539483mo_m__s
momus96116113mo_m_us
mondos95217333mondo_s
mongoes103415713mongoes
mongols103310823mongols
mongos94318623mongo_s
monists93614783monists
monocots1249813monocots
monos75930863mo_no_s
moods85224623mo__ods
mools76027173mo__ols
moons75331003mo__ons
moors74923143mo__ors
moos66051303mo__o_s
moot67653623mo__ot_
moppets13307163moppets
morions94014633morions
morons84919543mo_rons
morros83714673morro_s
morrows12318723morrows
morts75533563mo__rts
mostests1036833mostests
mosts76028543mo__sts
motels83616893mot_els
motes75944003mot__es
motet75641193mot_et_
mothers123717623mothers
moths106021553mot__hs
motifs1139673mot_ifs
motiles93317433motiles
motion85217553motio_n
motives123611893motives
motleys1235683motleys
motor75317293mot_o_r
mots66853163___mots
mott66648443mot__t_
motte75526973mot__te
mottes85523693mot_tes
mottles93415803mottles
motto76119513mot__to
moults84713703mo_ults
mounts84115073mo_unts
moutons9410313moutons
mozos165516333mo_zo_s
mutants938583mutants
mutons84314363mut_ons
muttons949283muttons
mutts75120253mut__ts
myotomes1546233myotomes
mythos14398463mytho_s
nomos75919743no_mo_s
notions74014483notions
omits75018253_o_mits
oots46446443_o__ots
osmols8137313_osmols
osmous8138183_osmous
ottos54714323_otto_s
outmost9511213outmost
pomos95321583po_mo_s
potboys1475273potboys
pothos114214693potho_s
potions93417423potions
potshots1346283potshots
pottos84615873potto_s
robots8313143ro_bots
roots55933673ro__ots
rotguts833763rotguts
rotors64917933rot_ors
rotos56027883rot_o_s
soots55536203so__ots
sotols63714453sot_ols
stots54828543_st_ots
tomtits937243tomtits
toots55331873__toots
topmost1148173topmost
tots46654123__t_ots
towmonts1364283towmonts
trots56629943__trots
utmost878483_utmost
utmosts934593_utmosts
vomits112610923vo_mits

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271647.79617191.8
3Display Results1641640.0632603.2
 (SQL Overall)1786911647.99922339.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.