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

206 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
morrows1231872(None) 
borrows12349261borrows
marrows122911831marrows
morros83714671morro_s
morrow113510091morrow_
sorrows10278401sorrows
arrows92813492_arrows
barrows123411692barrows
borrow114310732borrow_
burrows12399102burrows
cornrows1345312cornrows
farrows13259792farrows
furrows13327792furrows
harrows132611042harrows
horrors1078692horrors
marrons93216972marrons
marrow112812612marrow_
marrowy15236092marrowy
mirrors938622mirrors
morions94014642morions
morons84919542mo_rons
morrions1077672morrions
morris83814732morr_is
morro73216952morro__
narrows10258852narrows
sorrow9339442sorrow_
tomorrows1452242tomorrows
yarrows13277862yarrows
amorous9311133amo_rous
arrow83414893_arrow_
arrowy12288283_arrowy
barlows12259983barlows
barrow114512773barrow_
borons85520543bo_rons
borrowed1465053borrowed
borrower1384843borrower
borrowers1474033borrowers
borzois1835833borzois
bowwows1454123bowwows
brows105425983__brows
burros85114993burro_s
burrow114610813burrow_
carroms11512403carroms
carrots9714623carrots
cirrous93111063cirrous
cordons104415763cordons
cormous11312353cormous
cornrow1245603cornrow_
corrals93713853corrals
corries94026803corries
corrode101310573corrode
corrodes111310333corrodes
corrody13136143corrody
crows105727313__crows
dobros93910233dobro_s
dorrs65520593dorr__s
errors63311313_errors
escrows1235803escrows
farrow12309983farrow_
ferrous1049803ferrous
fogbows1643853fogbows
follows13409923follows
fordoes11311963fordoes
forgoes11311353forgoes
formols12299413formols
frows116623103__frows
furrow12427743furrow_
furrowy16384473furrowy
garrons82713463garrons
gorgons938853gorgons
grows95523923__grows
harrow122610783harrow_
hollows134412333hollows
horror988723horro_r
hotrods1148283hotrods
karroos1139313karroos
kotows13446523ko_tows
kouros1039183kouro_s
kowtows1742763kowtows
lorries74518353lorries
lowbrows1643483lowbrows
macrons113514893macrons
macros104017013macro_s
mallows123714323mallows
marmots11311513marmots
maroons92615553maroons
marrams11310123marrams
marrers93414313marrers
marries93825283marries
marron83717543marro_n
marrowed1445993marrowed
matrons93517633matrons
meadows1337333meadows
mellows123812233mellows
meows104612683m__eows
merlons93311273merlons
merlots92710123merlots
metros84217803metro_s
miaows1145473m_iaows
microns113814783microns
micros104115363micro_s
mikrons13428413mikrons
minnows1234913minnows
mirror848003mirro_r
misgrows1444963misgrows
moires8915633moir_es
mojoes15399523mo_joes
mojos145314463mo_jo_s
mondos95217333mondo_s
mongoes103415713mongoes
mongols103310823mongols
mongos94318623mongo_s
monos75930863mo_no_s
monurons1037093monurons
moods85224623mo__ods
mools76027173mo__ols
moonbows1543953moonbows
moons75331003mo__ons
moorfowl1651873moorfowl
moorfowls1751533moorfowls
moors74923143mo__ors
moos66051303mo__o_s
moots75831663mo__ots
morales93619403morales
morals85324643mo_rals
moras76438783mo_r_as
morass84614503mo_rass
morays114613883mo_rays
moreens939963moreens
morels84820023mo_rels
mores76249643mo_r_es
morgans10310123morgans
morgens10310463morgens
morgues1038273morgues
morion86217733morio_n
morns75527443mo_r_ns
moron76925423mo_ro_n
morose85116243mo_rose
morphos14159083morphos
morphs13149433mo_rphs
morrion959003morrion
morrises10711073morrises
mors65950063mo_r__s
morsels94112663morsels
mortals93914013mortals
mortars93411523mortars
morts75533563mo_r_ts
morulas959723morulas
motions94215003motions
motmots1166133motmots
motors84616603mo_tors
mottoes93412193mottoes
mottos84615243motto_s
mourns84111013mour_ns
moutons9410313moutons
mows96340833m___ows
mozos165516333mo_zo_s
murras84916013murr_as
murres85019043murr_es
murreys12367323murreys
murrhas12286173murrhas
murries94118673murries
murrs75521303murr__s
myrrhs1443603myrr_hs
narrow9269153narrow_
ordos65216203_ordo_s
orlons6411013_orlons
orlops847303_orlops
orris54516553_orr_is
orzos143311253_orzo_s
outrows10311403outrows
oxbows1833713_oxbows
parrots9312743parrots
perrons93115483perrons
pogroms1237643pogroms
pornos85015253porno_s
porous84419483po_rous
powwows1442853powwows
prows106327013__prows
pyrrols1235403pyrrols
regrows11269153regrows
rows75941753___rows
serows96016393_serows
sordors8310013sordors
sorgos74514663sorgo_s
sorrels7310723sorrels
sorrowed1264843sorrowed
sorrower1165053sorrower
sorrowers1274763sorrowers
sparrows1344813sparrows
strows96718273_strows
terrors73112213terrors
throws129715233_throws
tomorrow1342083tomorrow_
toreros7311343torero_s
toros54336193to_ro_s
torous64319033to_rous
torpors939383torpors
torrs53923563torr__s
torsos64815733torso_s
trows88826183__trows
upgrows1334323upgrows
vrows116115263__vrows
worries104117133worries
worrits10258683worrits
yarrow12287943yarrow_

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272066.82619634.8
3Display Results2062060.0802575.0
 (SQL Overall)1786912067.31224438.0
 
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.