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

244 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
meter7513032(None) 
deter65028041deter
mater74438861mater
meeter83616501meeter
melter83520111melter
merer75126231merer
mete64438131mete_
meted85424431meted
meteor84910071meteor
meters85625831meters
metes74736211metes
metier83517691metier
metre74821301metre
miter75734791miter
muter74525541muter
peter74427591peter
aether94213672aether
after85719792after
alter54828502alter
ameer75618982ame_er
ammeter1148392ammeter
apter76120202apter
aster55434892aster
beater84729392beater
beer65635992be_er
belter84720962belter
betel74419902betel
better84723702better
biter75030032biter
cater74840722cater
ceder85322242ceder
center84421412center
cete64934782cete_
cetes75731102cetes
citer74827332citer
cuter74728232cuter
dater65332312dater
deer56739022de_er
defer94619752defer
defter104215922defter
deters74724682deters
dexter143810892dexter
dieter73516772dieter
dimeter10411892dimeter
doter65428622doter
eater54639842eater
eger55923572_eger
ember95516802ember
emeer74815362emeer
emmer94314462emmer
emoter85415192emoter
enter54726382enter
ester54727712ester
ether84518772_ether
ever77027692_ever
ewer77523982_ewer
eyer76127282_eyer
feater95224052feater
fester94723512fester
fete75734922fete_
feted94420932feted
fetes85630142fetes
fetor81214532fetor
fetter94120382fetter
fever115617952fever
fewer115216122fewer
feyer115014522feyer
gater64533652gater
getter74117612getter
hater85034752hater
heater94828302heater
heder95623642heder
hefter124313922hefter
hetero9312632hetero
hewer115719932hewer
hexer155116682hexer
inter55028492inter
jeer115426462je_er
jester134319152jester
jete115927252jete_
jetes124922842jetes
kelter103214382kelter
kiter95523222kiter
later54843922later
leer46239352le_er
lefter93613432lefter
leger65721512leger
leper74820742leper
letter63722582letter
lever85125162lever
liter54736342liter
macer912126942macer
maker114127812maker
maser75029972maser
master84831342master
mate65154222mate_
mated85537782mated
maters85032392maters
mates75251362mates
matey107022662matey
matier84321522matier
matter84325342matter
mazer165722422mazer
meager94515202meager
meaner84617842meaner
meated94222402meated
meatier93214612meatier
meed74934702me_ed
meek105624832me_ek
meeker12359982meeker
meet65350552me_et
meeters94714542meeters
meets74224612meets
meister93114162meister
melder93915812melder
melee73729102melee
melted94219062melted
melters93918312melters
member12258852member
meme85330552meme_
memes94927702memes
mender93520792mender
mentee84121292mentee
mentor8414362mentor
mercer105214202mercer
mere67244442mere_
meres75143572meres
merger95016482merger
mestee84523882mestee
met56072432met__
meta65932412met_a
metal75427382metal
metamer1139612metamer
meteors94610012meteors
metepa1066012metepa
metered103514012metered
meth95827842met_h
meths105320232meths
metiers93312842metiers
metis75025902metis
metol75917812metol
metred95315142metred
metres85121562metres
metro74718802metro
mewed115218012mewed
mewler113510232mewler
meze154420902meze_
mezes167719262mezes
miler75733062miler
milter84921232milter
mimer94825762mimer
miner76933542miner
minter84425102minter
miser75430402miser
mister84728562mister
mite66249422mite_
miters84328782miters
mites75141802mites
mither114218562mither
mitier83620672mitier
mitre75522422mitre
mixer145017642mixer
molter84119422molter
mooter83921092mooter
moper94925922moper
mote67048082mote_
motel76623242motel
motes75944002motes
motet75641192motet
motey105922952motey
mother113718642mother
motor75317292motor
mover104220862mover
mower104523452mower
muser76024122muser
muster84724522muster
mute65136872mute_
muted85023382muted
mutes75033782mutes
mutter84418882mutter
neater64424312neater
nester64124182nester
nether94014162nether
netter63722022netter
neuter63713792neuter
never86218642never
newer85717462newer
niter55028972niter
noter55025642noter
oater55433732oater
ofter84116872ofter
otter54423972otter
outer55633302outer
oxter123414092oxter
pater74740732pater
peer66238352pe_er
pelter83321622pelter
perter84422282perter
pester84827592pester
peters86624592peters
petter83924772petter
pewter114013672pewter
rater54943282rater
refer84822142refer
renter64527412renter
rester63832432rester
rete44944132rete_
retear63115482retear
retem74221952retem
seater64534162seater
seder64826762seder
seer45547042se_er
serer55935512serer
setter64023722setter
sever85426052sever
sewer84426222sewer
smelter93311912smelter
smiter83616412smiter
steer55423862steer
tater54138612tater
teeter65420312teeter
tenter64623932tenter
tester64227152tester
tether93716102tether
tetter64322452tetter
titer55430612titer
toter55932132toter
ureter6313202ureter
utter54218762utter
veer76229572ve_er
venter94218722venter
vetoer93410062vetoer
vetter93417642vetter
vexer155513522vexer
voter85121052voter
water84733322water
weber10313522weber
weer75535092we_er
welter93417382welter
wester94222892wester
wether123315392wether
wetter93919442wetter
yester93417982yester
zester153617792zester

Search took 5 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.606294869.6
2DLD Change Limit538002443.33016156.2
3Display Results2442440.1401742.9
 (SQL Overall)1786912444.07643839.8
 
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.