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

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

216 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
meted8542443(None) 
feted94420931feted
mated85537781mated
meated94222401meated
meed74934701me_ed
melted94219061melted
mete64438131mete_
meter75130321meter
metes74736211metes
metred95315141metred
mewed115218011mewed
muted85023381muted
acted88521732acted
anted66328242anted
bated85935532bated
belted94020632belted
bested94922752bested
betel74419902betel
betted94721162betted
ceded96118552ceded
cered85227442cered
cete64934782cete_
cetes75731102cetes
cited84421952cited
coted85033852coted
dated75530992dated
deed65340902de_ed
deked115718532deked
deled75326542deled
dented84120512dented
deter65028042deter
dewed105020302dewed
dieted83115492dieted
doted75227072doted
dueted84113592dueted
eked96718022_eked
embed105014292embed
emoted94614922emoted
exed125420592_exed
eyed86623232_eyed
fated95632132fated
feed84538902fe_ed
felted103714652felted
fete75734922fete_
fetes85630142fetes
fetid93715982fetid
fetted104817892fetted
feued94715662feued
gated75329772gated
geed65435502ge_ed
hated95734022hated
heated104525592heated
heed86437602he_ed
hefted134911422hefted
hented104218752hented
hewed125619432hewed
hexed165615762hexed
jeed125428502je_ed
jested144416502jested
jete115927252jete_
jetes124922842jetes
jetted143915082jetted
jewed165114832jewed
keyed1369382keyed
kited105120092kited
lated65240672lated
letted74118542letted
luted64826142luted
maced108528692maced
malted94819852malted
maned86634092maned
marted94425212marted
masted94025802masted
mate65154212mate_
mater74438862mater
mates75251362mates
matey107022662matey
matted94521412matted
mawed115824742mawed
maxed155821192maxed
mayed115522402mayed
mazed175523872mazed
mead75531602me_ad
med66146742m__ed
meeds84920272me_eds
meek105624832me_ek
meet65350552me_et
meeter83616502meeter
meets74224612meets
meld75830472me_ld
melded104714712melded
melee73729102melee
melled95023022melled
melter83520112melter
meme85330552meme_
memes94927702memes
menad85918982menad
mend75334022me_nd
mended104418682mended
mensed93916542mensed
mentee84121292mentee
meoued9118532meoued
meowed12148002meowed
merde84320122merde
mere67244442mere_
merer75126232merer
meres75143572meres
merged104214942merged
merited10313852merited
meshed124415932meshed
messed95018182messed
mestee84523882mestee
met56072432met__
meta65932412met_a
metal75427382metal
metaled102913872metaled
meteor84910072meteor
metepa1066012metepa
metered103514012metered
meters85625832meters
meth95827842met_h
method1239022method
meths105320232meths
metier83517692metier
metis75025902metis
metol75917812metol
metre74821302metre
metres85121562metres
metro74718802metro
mettled103510542mettled
mewled123710052mewled
meze154420902meze_
mezes167719262mezes
miked125020452miked
milted93919942milted
mimed105622732mimed
mined85333352mined
minted94220582minted
mired85729222mired
misted93625822misted
mite66249402mite_
miter75734792miter
mites75141802mites
mitred94414342mitred
mixed155717252mixed
moated94819002moated
molted94217472molted
mooed85123982mooed
mooted94120372mooted
moped105424732moped
mote67048082mote_
motel76623242motel
motes75944002motes
motet75641192motet
motey105922952motey
moved114218152moved
mowed113629012mowed
muled85824432muled
mured85726702mured
mused85524582mused
musted93321072musted
mute65136872mute_
muter74525542muter
mutes75033782mutes
need54934152ne_ed
nested74720062nested
netted74118712netted
noted65123842noted
omened93711002omened
opted84914272opted
outed65429062outed
pated85237842pated
peed76239182pe_ed
pelted94617752pelted
peter74427592peter
petted94121522petted
rated65441382rated
reded74829112reded
reed55549622re_ed
refed93921922refed
rented74426592rented
rested74430782rested
rete44944132rete_
retem74221952retem
retied75924982retied
retted74826312retted
rewed95425452rewed
sated66238532sated
seated75131052seated
seed55549482se_ed
sered65737292sered
sewed95325162sewed
sexed136618542sexed
sited65130742sited
smelted10399092smelted
steed66024942steed
teated74924022teated
ted46446562__ted
teed55439262te_ed
tented74221002tented
tested74421522tested
tewed94718532tewed
toted64929482toted
vented104617922vented
vested104217352vested
vetoed10359822vetoed
vetted104316322vetted
vexed165713112vexed
voted93919142voted
weed85637512we_ed
weeted103913792weeted
welted103715822welted
wetted103717022wetted
wited94727142wited
wyted12529472wyted
zested164214042zested

Search took 3 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 Filter178691538000.0762351197.4
2DLD Change Limit538002161.86028924.7
3Display Results2162160.0633428.6
 (SQL Overall)1786912161.99989390.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.