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

427 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
meteor8491007(None) 
meteors94610011meteors
meter75130321mete_r
bettor83612222bettor
deter65028042dete_r
fetor81214532fet_or
hetero9312632hetero
mater74438862mate_r
meeter83616502meeter
melter83520112melte_r
mentor8414362mentor
merer75126232mere_r
mete64438132mete__
meted85424432mete_d
meteoric1247302meteoric
metepa1066012metepa
meters85625832meters
metes74736212mete_s
method1239022method
metier83517692metier
metol75917812met_ol
metro74718802metro_
metros84217802metros
miter75734792mite_r
motor75317292mot_or
muter74525542mute_r
peter74427592pete_r
retear63115482retear
vetoer93410062vetoer
abettor956193abettor
actor71116073act_or
aether94213673aether
after85719793afte_r
alter54828503alte_r
amateur933883amateur
ameer75618983ame_e_r
ammeter1148393ammete_r
apter76120203apte_r
aster55434893aste_r
auteur6107943auteur
author939763author
beater84729393beate_r
beer65635993be_e_r
belter84720963belte_r
betel74419903bete_l
betels84515063betels
bethorn1238643bethorn
beton76022063bet_on
betook12439603betook
better84723703better
bettors93312473bettors
bevor101510813be_vor
biter75030033bite_r
buteo75419893buteo_
buteos84913413buteos
cater74840723cate_r
ceder85322243cede_r
censor84011293censor
center84421413cente_r
cete64934783cete__
cetes75731103cete_s
citer74827333cite_r
cuter74728233cute_r
dater65332313date_r
debtor938333debtor
decor84717573de_cor
deer56739023de_e_r
defer94619753defe_r
defter104215923defte_r
detect94217403detect
detector11278323detector
detent73624483detent
deters74724683deters
detest74122843detest
detour778193detour
detox13310953det_ox
dexter143810893dexte_r
dieter73516773diete_r
dimeter10411893dimete_r
doter65428623dote_r
eater54639843eate_r
eger55923573_ege_r
ember95516803embe_r
emeer74815363_emeer
emmer94314463emme_r
emoter85415193emote_r
emperor1155483emperor
enter54726383ente_r
ephor10310013_ephor
error53712233_error
ester54727713este_r
ether84518773_ether
ethos85514193_ethos
ever77027693_eve_r
ewer77523983_ewe_r
eyer76127283_eye_r
feater95224053feate_r
fervor1235643fervor
fester94723513feste_r
fete75734923fete__
feted94420933fete_d
fetes85630143fete_s
fetors91014473fet_ors
fetter94120383fetter
fever115617953feve_r
fewer115216123fewe_r
feyer115014523feye_r
foetor939563foet_or
gater64533653gate_r
gator64416033gat_or
getter74117613getter
hater85034753hate_r
heater94828303heate_r
hector113312653hector
heder95623643hede_r
hefter124313923hefte_r
hereof123212373hereof
hereon93914363hereon
heteros10312683heteros
hewer115719933hewe_r
hexer155116683hexe_r
inter55028493inte_r
jeer115426463je_e_r
jester134319153jeste_r
jete115927253jete__
jetes124922843jete_s
jeton124815403jet_on
jetport1646643jetport
jetsom15126143jetsom
jetton1338033jetton
kelter103214383kelte_r
ketene106613003ketene
keto86223453ket_o_
ketol95414003ket_ol
kiter95523213kite_r
later54843923late_r
lector83514983lector
leer46239353le_e_r
lefter93613433lefte_r
leger65721513lege_r
leper74820743lepe_r
lessor64010603lessor
letter63722583letter
lever85125163leve_r
liter54736343lite_r
macer912126943mace_r
mahzor2035113mahzor
major145212923m_ajor
maker114127813make_r
manor78023933m_anor
maser75029973mase_r
master84831343maste_r
matador1066253matador
mate65154223mate__
mated85537783mate_d
matelot9411573matelot
maters85032393maters
mates75251363mate_s
matey107022663mate_y
mateys115610943mateys
matier84321523matier
matron83918313matron
matter84325343matter
matzo16312893matzo_
matzoh2035483matzoh
matzos1749263matzos
matzot17710983matzot
mayor106616623m_ayor
mazer165722423maze_r
meadow1237403meadow
meager94515203meager
meaner84617843meaner
meated94222403meate_d
meatier93214613meatier
medlar93010463medlar
meed74934703me_e_d
meeds84920273me_eds
meek105624833me_e_k
meeker12359983meeker
meet65350553me_e_t
meeters94714543meeters
meetly1138673meetly
meets74224613me_ets
meister93114163meiste_r
melder93915813melder
melee73729103mele_e
melees83618083melees
melena81110473melena
mellow114112223mellow
melon73922083me_lon
melted94219063melte_d
melters93918313melters
melton8311553melton
member12258853member
meme85330553meme__
memes94927703meme_s
memo85924793me_mo_
memoir1037213memoir
memory1338803me_mory
memos95719113me_mos
mender93520793mender
menhir1136783menhir
meno66031363me_no_
mentee84121293mente_e
mentees93214503mentees
menthol1236723menthol
mention9314373mention
mentors9314993mentors
meou65325863m__eou
meow95117883m__eow
mercer105214203mercer
mere67244443mere__
merely111312593merely
meres75143573mere_s
merest84725113merest
merger95016483merger
merlon83012353merlon
merlot83217603merlot
meson74118313me_son
mestee84523883meste_e
mestees94617753mestees
mesteso937133mesteso
mestesos1045223mestesos
met56072433met___
meta65932413met__a
metage93114453metage
metal75427383met_al
metals84520883metals
metamer1139613metamer
metaphor1544913metaphor
metate82720533metate
metazoa1845543metazoa
meteorite1148173meteorite
meteoroid1245113meteoroid
metepas1136303metepas
metered103514013metered
meth95827843met__h
methods1338883methods
methoxy2243943methoxy
meths105320233met_hs
methyl1436403methyl
metiers93312843metiers
meting94320593meting
metis75025903met_is
metols84115773metols
metope10611123metope
metopon11137073metopon
metre74821303met_re
metred95315143metred
metres85121563metres
metric10314673metric
mettle83815723mettle
metump1235713metump
mewed115218013mewe_d
mewler113510233mewler
meze154420903meze__
mezes167719263meze_s
mezzo1537433mezzo_
mezzos1635053mezzos
miler75733063mile_r
milter84921233milte_r
mimeo96018683mimeo_
mimeos104511543mimeos
mimer94825763mime_r
miner76933543mine_r
minor74920063m_inor
minter84425103minte_r
mirror848003mirror
miser75430403mise_r
mister84728563miste_r
mite66249413mite__
miterer92511333miterer
miters84328783miters
mites75141803mite_s
mither114218563mither
mitier83620673mitier
mixer145017643mixe_r
molter84119423molte_r
montero9310133montero
moor66628553m__oor
mooter83921093moote_r
moper94925923mope_r
mor56855003m___or
mote67048083mote__
motel76623243mote_l
motels83616893motels
motes75944003mote_s
motet75641193mote_t
motets84216193motets
motey105922953mote_y
mother113718643mother
motion85217553motion
motmot10311073motmot
motors84616603mot_ors
motto76119513motto_
mottos84615243mottos
mover104220863move_r
mower104523453mowe_r
mucor94011943m_ucor
muleteer1044703muleteer
muser76024123muse_r
muster84724523muste_r
mute65136873mute__
muted85023383mute_d
mutely113811653mutely
mutes75033783mute_s
mutest84218053mutest
muton73817003mut_on
mutter84418883mutter
mutton8510453mutton
mythoi14417133mythoi
mythos14398463mythos
neater64424313neate_r
nester64124183neste_r
nestor63713423nestor
nether94014163nether
netop7312343net_op
netter63722023netter
network1446803network
neuter63713793neute_r
never86218643neve_r
newer85717463newe_r
niter55028973nite_r
noter55025643note_r
oater55433733oate_r
ofter84116873ofte_r
otter54423973otte_r
outer55633303oute_r
oxter123414093oxte_r
pater74740723pate_r
peer66238353pe_e_r
pelter83321623pelte_r
pereon83517453pereon
perter84422283perte_r
pester84827593peste_r
peters86624593peters
petrol82714063petrol
petter83924773petter
petto76021043petto_
pewter114013673pewte_r
pretor8315753pret_or
rater54943283rate_r
rector84019753rector
redear73515173redear
refer84822143refe_r
regear73512743regear
rehear93713223rehear
renter64527413rente_r
rester63832433reste_r
rete44944133rete__
reteam83214533reteam
retears72814923retears
retell63813643retell
retem74221953rete_m
retems83914573retems
retene69224273retene
retest64028453retest
retook104313443retook
retool63914483retool
retore67630773ret_ore
retorn610923433ret_orn
retort66831153ret_ort
retro55020953retro_
retros63820193retros
rewear93012003rewear
rezero1578873rezero
rhetor938063rhet_or
rotor55519733rot_or
seater64534163seate_r
sector83415933sector
seder64826763sede_r
seer45547043se_e_r
seisor63712343seisor
seizor15428533seizor
senhor93010813senhor
senior63214053senior
senor53822803se_nor
sensor63813843sensor
serer55935513sere_r
seton55223543set_on
setter64023723setter
settlor7314733settlor
sever85426053seve_r
sewer84426223sewe_r
smelter93311913smelte_r
smiter83616413smite_r
steer55423863_steer
tater54138613tate_r
tear45242883__tear
teeter65420313teeter
tenor53620253te_nor
tensor63812673tensor
tenter64623933tente_r
termor84412513termor
terror63811733terror
tester64227153teste_r
tether93716103tether
tetter64322453tetter
titer55430613tite_r
tor39261683__t_or
toter55932133tote_r
tutor5712493tut_or
uptear896783uptear
ureter6313203urete_r
utter54218763utte_r
vector113212063vector
veer76229573ve_e_r
vendor10359803vendor
veneer94511693veneer
venter94218723vente_r
veto76622993vet_o_
vetoed10359823vetoed
vetoers10359473vetoers
vetoes92914083vetoes
vetter93417643vetter
vexer155513523vexe_r
voter85121053vote_r
water84733313wate_r
weber10313523webe_r
weer75535093we_e_r
weldor10317653weldor
welter93417383welte_r
wester94222893weste_r
wether123315393wether
wetter93919443wetter
yester93417983yeste_r
zester153617793zeste_r

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127164275.26621404.5
3Display Results4274270.1263388.9
 (SQL Overall)1786914275.76530995.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.