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

183 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
methods133888(None) 
method1239021method_
ephods1238362_ephods
ethos85514192_etho_s
menthols1347032menthols
meteors94610012meteors
methodic1656912methodic
methodise1545512methodise
methodism1745232methodism
methodist1547012methodist
methoxy2243942methoxy
meths105320232meth__s
methyls1535452methyls
metols84115772met_ols
metros84217802metro_s
mythos14398462mytho_s
aethers103614943aethers
anethols1145843anethols
authors10311833authors
bathos116215633batho_s
beholds1336423be_holds
benthons1337973benthons
benthos1238373bentho_s
bethels1238533bethels
bethorn1238643bethorn
bethorns1337323bethorns
beths105519223beth__s
betons84919553bet_ons
bettors93312473bettors
cathode1338993cathode
cathodes1439373cathodes
echoes114715523_echoes
echos105216463_echo_s
emerods10137653emerods
ephod1139123_ephod_
ephors11311403_ephors
ethers94518413_ethers
ethics11169283_ethics
ethions1038483_ethions
ethmoids1444053_ethmoids
ethnos947053_ethnos
ethoses10311753_ethoses
ethoxy1933923_ethoxy
eths76619523_eth__s
ethyls1235903_ethyls
fathoms1537523fathoms
feods99516853fe__ods
fetors91014473fet_ors
heths116317783heth__s
hods87239863___hods
hotrods1148283hotrods
jehads1735833je_hads
jetons134512613jet_ons
jetsoms16124723jetsoms
jettons1437273jettons
kathode1545733kathode
kathodes1646183kathodes
ketols104210763ket_ols
lethals1038113lethals
lethes94818083leth_es
lithops12307253lithops
lithos94212553litho_s
machos135217493macho_s
mahoes11313103m_ahoes
manhoods1447243manhoods
maths105624023math__s
matrons93517633matrons
mattoids1196183mattoids
matzohs2134373matzohs
matzos1749263matzo_s
meadows1337333meadows
meads85425323me__ads
meatheads1545963meatheads
meds75735363me___ds
meeds84920273me__eds
megapods1444893megapods
megohms1592863megohms
mehndi1233153me_hndi
mehndis1343583me_hndis
melds84822383me__lds
mellows123812233mellows
melody1237203me_lody
meloids10911443meloids
melons84117713me_lons
meltons9410923meltons
memos95719113me_mo_s
menads95514383me_nads
mends84927693me__nds
menhirs1235913menhirs
menthol1236723mentho_l
mentions10312893mentions
mentors9314993mentors
menudos1034643menudos
meous76120063me__ous
meows104612683me__ows
merlons93311273merlons
merlots92710123merlots
meshed124415933meshed_
meshes115019443mesh_es
mesons83215843me_sons
metages102714973metages
metals84520883met_als
metaphors1645683metaphors
metates92720003metates
meted85424433met_ed_
meteor84910073meteo_r
metepas1136303metepas
meters85625833met_ers
metes74736213met__es
meth95827843meth___
methadon1444523methadon
methadons1544423methadons
methane123211793methane
methanes133812163methanes
methanols1444863methanols
methinks1775193methinks
methodised1753783methodised
methodises1645463methodises
methodisms1844563methodisms
methodists1644963methodists
methodize2445713methodize
methodizes2545583methodizes
methoxide2244173methoxide
methoxides2344023methoxides
methoxyl2342733methoxyl
methyl1436403meth_yl
metiers93312843metiers
metis75025903met__is
metol75917813met_o_l
metope10611123met_ope
metopes11311363metopes
metopons12107023metopons
metred95315143metred_
metres85121563met_res
metrics11312363metrics
metro74718803metro__
mettles94115023mettles
metumps1334133metumps
mezzos1635043mezzo_s
mhos95517773m__ho_s
mithers123516733mithers
mods77945053m___ods
moods85224623m__oods
mothers123717623mothers
moths106021553moth__s
motions94215003motions
motmots1166133motmots
motors84616593mot_ors
mottoes93412193mottoes
mottos84615243motto_s
mutons84314363mut_ons
muttons949283muttons
mythoi14417123mytho_i
myths135911603myth__s
netops839213net_ops
pathos115516693patho_s
periods10312243periods
pernods1038483pernods
petards104311153petards
petrols92913083petrols
petrous92714423petrous
pothos114214693potho_s
pythons1537363pythons
reshod103012233reshod_
reshoes102316033reshoes
reshows132510453reshows
resods74116303re_sods
retards85015003retards
retools73411023retools
retros63820193retro_s
senhors103512123senhors
setons64620173set_ons
setous64917373set_ous
tethers103815313tethers
teths85418513teth__s
tetrads82910173tetrads
tetrode839333tetrode
tetrodes939073tetrodes
thous86017253__thous
thuds95110133__thuds
tods56141843__t_ods
vetoes92914083vet_oes
wethers135214693wethers

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.1561145455.1
2DLD Change Limit1340271837.51617832.2
3Display Results1831830.0632904.8
 (SQL Overall)1786911837.73523101.6
 
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.