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

361 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
meteors9461001(None) 
meteor84910071meteor_
meters85625831mete_rs
bettors93312472bettors
deters74724682dete_rs
fetors91014472fet_ors
heteros10312682heteros
maters85032392mate_rs
meeters94714542meeters
melters93918312melte_rs
mentors9314992mentors
meteoric1247302meteoric
metepas1136302metepas
meter75130322mete_r_
metes74736212mete__s
methods1338882methods
metiers93312842metiers
metols84115772met_ols
metros84217802metro_s
miters84328782mite_rs
motors84616602mot_ors
peters86624592pete_rs
retears72814922retears
vetoers10359472vetoers
abettors1056133abettors
actors81016763act_ors
aeneous739893aeneous
aethers103614943aethers
afters94717073afte_rs
alters64924223alte_rs
amateurs1043643amateurs
ameers84015573ame_e_rs
ammeters1237693ammete_rs
asters65631603aste_rs
auteurs7137503auteurs
authors10311853authors
beaters94925043beate_rs
beers75628393be_e_rs
belters93819413belte_rs
betels84515063bete_ls
bethorn1238643bethorn
bethorns1337323bethorns
betons84919553bet_ons
betters94422093betters
bettor83612223bettor_
bevors111610343be_vors
biters83925243bite_rs
buteos84913413buteo_s
caters85336503cate_rs
ceders93817673cede_rs
censors93611843censors
centers94420603cente_rs
cetes75731103cete__s
citers85022983cite_rs
daters74827373date_rs
debtors1038533debtors
decors94017773de_cors
deers64930523de_e_rs
defers105116943defe_rs
detectors12278303detectors
detects104011093detects
detents83615153detents
deter65028043dete_r_
detests83711743detests
detours858043detours
dieters83216433diete_rs
dimeters11411093dimete_rs
doters74423913dote_rs
duteous838453duteous
eaters65535953eate_rs
egers65120373_ege_rs
embers104116183embe_rs
emeers83314183_emeers
emmers104013223emme_rs
emoters94712873emote_rs
emperors1256123emperors
enters64425643ente_rs
ephors11311403_ephors
errors63311313_errors
esters64627733este_rs
ethers94518413_ethers
ethos85514193_etho_s
ewers86018823_ewe_rs
eyers86521333_eye_rs
fervors1336233fervors
festers104121393feste_rs
fetes85630143fete__s
fetor81214533fet_or_
fetters103517903fetters
fevers125414893feve_rs
foetors1039763foet_ors
gaters74728643gate_rs
gators74115833gat_ors
getters84216103getters
haters94930403hate_rs
heaters104225223heate_rs
hectors123513263hectors
heders104119763hede_rs
hefters134312003hefte_rs
hetero9312633hete_ro
hewers123715273hewe_rs
hexers165612753hexe_rs
inters64328053inte_rs
jeers124818133je_e_rs
jesters144118193jeste_rs
jetes124922843jete__s
jetons134512613jet_ons
jetport1646643jetport
jetports1743533jetports
jetsoms16124723jetsoms
jettons1437273jettons
kelters113813753kelte_rs
ketenes114813503ketenes
ketols104210763ket_ols
kiters105218593kite_rs
lectors93415763lectors
leers54828983le_e_rs
legers74518313lege_rs
lepers84817323lepe_rs
lessors73610523lessors
letters73819853letters
levers94621323leve_rs
liters65429883lite_rs
luteous739273luteous
macers105321273mace_rs
mahzors2135123mahzors
majors154511093m_ajors
makers123921733make_rs
manors84420883m_anors
masers84623453mase_rs
masters94628923maste_rs
matadors1156983matadors
matelots1047533matelots
mater74438863mate_r_
mates75251363mate__s
mateys115610943mate_ys
matrons93517633matrons
matters94421753matters
matzohs2134373matzohs
matzos1749263matzo_s
mayors115714193m_ayors
mazers173917093maze_rs
meadows1337333meadows
meaners94415243meaners
medlars10259443medlars
meeds84920273me_e_ds
meeter83616503meeter_
meets74224613me_e_ts
meisters103313843meiste_rs
melders103213913melders
melees83618083mele_es
melenas999203melenas
mellows123812233mellows
melons84117713me_lons
melter83520113melte_r_
meltons9410923meltons
members13258603members
memes94927703meme__s
memoirs1136803memoirs
memory1338803me_mory
memos95719113me_mo_s
menders103818803menders
menhirs1235913menhirs
mentees93214503mente_es
menthols1347033menthols
mentions10312893mentions
mentor8414363mentor_
meous76120063m__eous
meows104612683m__eows
mercers114412773mercers
merer75126233mere_r_
meres75143573mere__s
mergers103813423mergers
merlons93311273merlons
merlots92710123merlots
meseems1165603meseems
mesons83215843me_sons
mestees94617753meste_es
mestesoes1145323mestesoes
mestesos1045223mestesos
metages102714973metages
metals84520883met_als
metamers1249623metamers
metaphors1645683metaphors
metates92720013metates
mete64438133mete___
meted85424433mete__d
meteorite1148173meteorite
meteorites1247613meteorites
meteoroid1245113meteoroid
meteoroids1353813meteoroids
metepa1066013mete_pa
metered103514013metered
metestrus1143133metestrus
method1239023metho_d
methoxy2243943methoxy
meths105320233met__hs
methyls1535453methyls
metier83517693metier_
metis75025903met__is
metol75917813met_o_l
metope10611123met_ope
metopes11311363metopes
metopons12107023metopons
metre74821303met__re
metres85121563met_res
metrics11312363metrics
metro74718803met__ro
mettles94115023mettles
metumps1334133metumps
mewlers12288983mewlers
mezes167719263meze__s
mezzos1635053mezzo_s
milers84625163mile_rs
milters93619093milte_rs
mimeos104511543mimeo_s
mimers105520183mime_rs
miners84126633mine_rs
minors85117103m_inors
minters93822473minte_rs
mirrors938623mirrors
misers85025703mise_rs
misters93927513miste_rs
miter75734793mite_r_
miterers10219683miterers
mites75141803mite__s
mithers123516733mithers
mixers154513563mixe_rs
molters93816973molte_rs
monteros1039453monteros
moors74923143m__oors
mooters93818623moote_rs
mopers104220373mope_rs
mors65950063m___ors
motels83616893mote_ls
motes75944003mote__s
motets84216193mote_ts
mothers123717623mothers
motions94215003motions
motmots1166133motmots
motor75317293mot_or_
mottoes93412193mottoes
mottos84615243motto_s
movers115117193move_rs
mowers113219403mowe_rs
mucors104410853m_ucors
muleteers1143673muleteers
musers84719103muse_rs
musters94522513muste_rs
muter74525543mute_r_
mutes75033783mute__s
mutons84314363mut_ons
mutters94117143mutters
muttons949283muttons
mythos14398463mytho_s
nesters74422793neste_rs
nestors73614973nestors
netops839213net_ops
netters73618583netters
network1446803network
networks1546143networks
neuters74212273neute_rs
niters64624213nite_rs
noters64021003note_rs
oaters65029793oate_rs
otters64021513otte_rs
outers64230173oute_rs
oxters134813273oxte_rs
paters84935833pate_rs
peers75130273pe_e_rs
pelters93720313pelte_rs
pereons92815003pereons
pesters93827093peste_rs
peter74427593pete_r_
petrols92913083petrols
petrous92714423petrous
petters93722363petters
pewters124113353pewte_rs
piteous9310683piteous
pretors9316813pret_ors
raters63936583rate_rs
rectors93520523rectors
redears82814453redears
refers93921083refe_rs
regears83012463regears
rehears103312773rehears
renters74224813rente_rs
resters74130403reste_rs
reteams9339563reteams
retear63115483retear_
retells73211523retells
retems83914573rete_ms
retenes76324623retenes
retests73813853retests
retools73411023retools
retore67630773ret_ore
retorn610923433ret_orn
retort66831153ret_ort
retorts76016513ret_orts
retrorse837623retrorse
retros63820193retro_s
revers94529633reve_rs
rewears102911043rewears
rezeros1647453rezeros
rhetors1038513rhet_ors
rotors64917953rot_ors
seaters74028943seate_rs
sectors93116453sectors
seders74420283sede_rs
seers55136383se_e_rs
seisors73212843seisors
seizors16329013seizors
senhors103512133senhors
seniors73413623seniors
senors63620793se_nors
sensors73514643sensors
setons64620173set_ons
setous64917373set_ous
setters73822063setters
settlors8255013settlors
severs94121123seve_rs
sewers94719723sewe_rs
smelters103310513smelte_rs
smiters93414363smite_rs
steers63820983_steers
taters64932203tate_rs
tears55436463__tears
teeters74018303teeters
tenors63217753te_nors
tensors72712373tensors
tenters73921103tente_rs
termors94712773termors
terrors73112213terrors
testers74124543teste_rs
tethers103815313tethers
tetters74320473tetters
titers64526413tite_rs
tors46157383__t_ors
toters65026363tote_rs
tutors6912333tut_ors
uptears9106453uptears
ureters7311823urete_rs
utters63817123utte_rs
vectors123212593vectors
veers84521363ve_e_rs
vendors113510223vendors
veneers103710293veneers
venters103717733vente_rs
vetoer93410063vetoer_
vetoes92914083vet_oes
vetters104016323vetters
vexers165210403vexe_rs
voters95017443vote_rs
waters95030633wate_rs
webers11310943webe_rs
weldors11238003weldors
welters103516063welte_rs
westers105221963weste_rs
wethers135214693wethers
wetters103817753wetters
zesters163517293zeste_rs

Search took 7 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.403443402.0
2DLD Change Limit1340273616.09621986.1
3Display Results3613610.1402578.6
 (SQL Overall)1786913616.63926915.3
 
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.