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

233 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
monteros103945(None) 
montero9310131montero_
minters93822472minter_s
molters93816972molter_s
mongers104217272monger_s
monsteras11318242monsteras
monsters103314552monster_s
montes84226932monte__s
mooters93818622mooter_s
mounters103712502mounter_s
santeros8311192santeros
banters94623123banter_s
boaters93419243boater_s
boleros9310293bo_leros
bolters94017803bolter_s
bonders104120663bonder_s
boners84825433bon_er_s
bonkers134015303bonker_s
bontebok1641933bontebok
bonteboks1741823bonteboks
bunters94717123bunter_s
canters94827733canter_s
centers94420603center_s
coaters93525793coater_s
cointers103616423cointer_s
colters93522443colter_s
concerns122710833concerns
concertos132711133concertos
concerts123016063concerts
confers124120093confer_s
congers104223233conger_s
conkers133721043conker_s
conners94023113conner_s
contemns1237403contemns
contends112810573contends
contents104018213contents
contes84432913conte__s
contests103413383contests
contexts17378653contexts
contorts101112643contorts
contos84923233cont__os
contras93015623cont_ras
control9310693cont_rol
controls10311393cont_rols
converso1336423converso
conversos1446893conversos
converts133213553converts
cooters94525733cooter_s
copters113621283copter_s
costers94128343coster_s
cotters94323453cotter_s
counters103320193counter_s
couters93827303couter_s
dineros83812333din_eros
doters74423913do_ter_s
dotters83715973dotter_s
emoters94712873emo_ter_s
enteron7313343_enteron
enterons8314153_enterons
enters64425643_enter_s
footers104618333footer_s
fosters104220103foster_s
goiters84014443goiter_s
goners74420173gon_er_s
heteros10312683_heteros
hinters103719583hinter_s
honers94324973hon_er_s
honkers143315233honker_s
hooters104520483hooter_s
hunters103915733hunter_s
interns73116773_interns
inters64328053_inter_s
intros64215773_int_ros
jointers15289323jointer_s
jolters143711993jolter_s
jotters143413803jotter_s
lanterns838303lanterns
linters73822633linter_s
lofters103912903lofter_s
loiters74116613loiter_s
loners64225813lon_er_s
longeron945763longeron
longerons1045893longerons
longers84819543longer_s
looters74419163looter_s
lotters73921063lotter_s
mangers103521263manger_s
manners93417833manner_s
manteaus1036383manteaus
mantels94515043mante_ls
mantes84430783mante__s
mantras93815863mant_ras
masters94628923master_s
maters85032393m_ater_s
matters94421753matter_s
meeters94714543meeter_s
melters93918313melter_s
menders103818803mender_s
mentees93214503mente_es
mentors9314993mentor_s
mestesos1045223mestesos
meteors94610013m_eteors
meters85625833m_eter_s
metros84217803m_et_ros
midterms13284863midterms
milters93619093milter_s
mincers113714853mincer_s
minders103720123minder_s
miners84126633min_er_s
minsters103813923minster_s
minter84425103minter__
misterms123711353misterms
misters93927513mister_s
miters84328783m_iter_s
moaners92813553moaner_s
mobbers133610923mobber_s
mobsters12359063mobster_s
mockers153812943mocker_s
moderns1037963mo_derns
moilers93615203moiler_s
molders103315553molder_s
molter84119423molter__
momsers113810853momser_s
momzers20367133momzer_s
mondes94322353monde__s
mondos95217333mon__dos
moneran9311113mon_eran
monerans10310353mon_erans
moneyers1337423moneyer_s
moneys115513623mon_e_ys
monger94418333monger__
mongered1238953mongered
mongos94318623mon__gos
mongrels1135333mongrels
monies83233163monie__s
monikers1437413moniker_s
monitors10310823monitor_s
monkeries15129913monkeries
monkery16317453monker_y
monkeys16407423monke_ys
monomers12311033monomer_s
monos75930863mon___os
monster93214603monster__
monstera10318883monster_a
monstrous1187353monstrous
montages111412183montages
montanes101114523montanes
monte75829773monte___
monteith1375793monteith
monteiths1473553monteiths
months113812933mont__hs
monuron937463mon_uron
monurons1037093mon_urons
mooners94015343mooner_s
mooter83921093mooter__
mopers104220373mo_per_s
moppers133412463mopper_s
morros83714673mo__rros
mortars93411523mortar_s
moshers124017843mosher_s
mossers94116193mosser_s
mostests1036833mostests
motels83616903mo_te_ls
motes75944003mo_te__s
motets84216193mo_te_ts
mothers123717623mother_s
motors84616603mo_tor_s
mottes85523693motte__s
mottlers10388183mottler_s
mottos84615243mo_t_tos
moulters103510783moulter_s
mounter93713173mounter__
mousers95216443mouser_s
mouthers133811303mouther_s
movers115117193mo_ver_s
mowers113219403mo_wer_s
munsters104010553munster_s
musters94522513muster_s
mutters94117143mutter_s
nonegos837143non_egos
nonhero1057913nonhero_
nonheroes1247633nonheroes
nonpros937473non_pros
nonzero1646123nonzero_
noters64021003no_ter_s
oaters65029793_oater_s
onerous7312973_on_erous
otters64021513_otter_s
outers64230173_outer_s
oxters134813273_oxter_s
pointers103013723pointer_s
ponderosa1242683ponderosa
ponderous1267273ponderous
ponders103618843ponder_s
pontes83627853ponte__s
porters93722703porter_s
posterns102713723posterns
posters93928013poster_s
potters94024343potter_s
pouters94221873pouter_s
powters124015663powter_s
punters93617043punter_s
ranters73323643ranter_s
renters74224823renter_s
rooters74522933rooter_s
rosters73727553roster_s
rotters74421393rotter_s
routers74822873router_s
santeras8311063santeras
santero7311133santero_
sinters74024083sinter_s
sonders83820713sonder_s
sorters74221133sorter_s
souters74422603souter_s
tenters73921113tenter_s
tinters74221113tinter_s
toners64128003ton_er_s
tongers84116013tonger_s
tonners73816403tonner_s
tooters73818773tooter_s
toreros7311343to_reros
toters65026363to_ter_s
totters74618733totter_s
touters74018353touter_s
venters103717733venter_s
voters95017443vo_ter_s
wanters104420093wanter_s
winters103720483winter_s
wonders113315993wonder_s
wonners104312813wonner_s
yonkers14379823yonker_s
zoners155115993zon_er_s
zosters163015413zoster_s

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 Filter1786911461620.466383457.1
2DLD Change Limit1461622336.69021847.8
3Display Results2332330.0932505.4
 (SQL Overall)1786912337.24924650.4
 
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.