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

132 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
morassy1249504(None) 
morass84614501morass_
brassy11509232_brassy
grassy10619092_grassy
massy104518962m__assy
morally12411492morally
morals85324632morals_
moras76438782mora_s_
morasses1038902morasses
moray105423792mora__y
morays114613882morays_
mossy105217062mo__ssy
amorally1348093amorally
bassy1012917103__bassy
borals86721913borals_
boras75938303bora_s_
bossy105515973bo__ssy
brashy145210593_brashy
brass75428023_brass_
classy11379043_classy
corals85325143corals_
crass76328043_crass_
crassly1276653_crassly
cressy11439113_cressy
dressy10518143_dressy
drossy10528473_drossy
embassy1442703embassy
forams115115913forams_
foray115023973fora__y
forays124813003forays_
frass85321123_frass_
gassy95514023__gassy
glassy10527753_glassy
gorals76917653gorals_
gorsy95915783gor__sy
grass66125203_grass_
harass9313943harass_
horahs126313873horahs_
horary12310383hora_ry
horas86333103hora_s_
horsey125115403hor_sey
horsy116318393hor__sy
jorams154810533jorams_
koras95927113kora_s_
korats105416063korats_
lorans65117603lorans_
lossy85214643lo__ssy
madrassa11274633madrassa
maras75443293mara_s_
marasca1136823marasca
marshy14558333mar_shy
mashy136016503m__ashy
mass66044943m__ass_
massa75518923m__assa
masse75125293m__asse
matrass939403matrass_
measly113610443m_easly
megass9219443megass_
megasse10266243megasse
messy104913833m__essy
misassay1343203misassay
missy105617563m__issy
moans74624373mo_ans_
moas65545343mo_a_s_
moats75827643mo_ats_
modally1338403modally
modals93914453modals_
modesty13476983modesty
molars85517323molars_
molas75132093mola_s_
molasses1037233molasses
monads94515303monads_
monas74732153mona_s_
mora66641273mora___
morae75831193mora__e
moraine9314573moraine
moral75533433mora__l
morale85220553mora_le
morales93619403morales
moralise10314913moralise
moralism12312363moralism
moralist10316663moralist
morality131110333morality
moratory1347823moratory
mordancy1644193mordancy
morels84820013morels_
mores76249643mor_es_
morgans10310123morgans_
morns75527443mor_ns_
morons84919543morons_
morose85116243mor_ose
morosely1345713morosely
morosity1347293morosity
morphs13149433morphs_
morris83814733morris_
morros83714673morros_
mors65950063mor__s_
morse76032703mor__se
morsel85815893mor_sel
mortally1339933mortally
mortals93914003mortals_
mortars93411523mortars_
mortary12369043mortary
mortify1536223mortify
mortise9713533mortise
morts75533563mor_ts_
mosey105922873mo__sey
moss67641033mo__ss_
mosso74715183mo__sso
mousey115216193mo_usey
mousse84813033mo_usse
mousy106716943mo__usy
movably17167043movably
moxas145014393moxa_s_
murals84016763murals_
muras75329583mura_s_
mussy104117643m__ussy
orally93113593_orally
orals55826483_orals_
orangy105111233_orangy
prissy11347853_prissy
raspy106511703__raspy
sassy85813813__sassy
soras55041013sora_s_
strass67117223strass_
toasty9509563to_asty
torahs95115643torahs_
toras55540373tora_s_
trashy12509053_trashy
trass56226473_trass_
tressy9448553_tressy
wrasse9398773_wrasse

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 Limit1340271326.70319995.1
3Display Results1321320.0462869.6
 (SQL Overall)1786911327.15524974.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.