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

270 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
morulas95971(None) 
morula8710471morula_
morulae958961morulae
morular978221morular
torulas759851torulas
copulas113811562copulas
doulas75114992do_ulas
ferulas103110752ferulas
formulas1346302formulas
korunas1135442korunas
maculas113114022maculas
modular1087362modular
modulars1165832modulars
modules102511002modules
modulus10245332modulus
moguls948552mogul_s
molas75132092mo__las
moolas83615592mo_olas
morales93619402morales
morals85324632moral_s
moras76438782mor__as
morels84820012morel_s
mortals93914002mortals
moulds94910992mo_ulds
moults84713702mo_ults
torula6610392torula_
torulae758552torulae
zonulas1637022zonulas
aortas65417783aor_tas
bolas74733763bo__las
borals86721913boral_s
boras75938303bor__as
boreas85421733bor_eas
boules84925973bo_ules
boylas113011723bo_ylas
canulas9312853canulas
cedulas1058503cedulas
coalas87418963co_alas
colas75436773co__las
copula102812043copula_
copulae112810613copulae
copular113810603copular
corals85325143coral_s
corneas94717003corneas
corollas1039213corollas
coronas93916913coronas
corrals93713853corrals
coruler9311713coruler
corulers1039773corulers
coryzas2134803coryzas
coulis84018763co_ulis
courlan9117763courlan
courlans10117613courlans
doblas93812293do_blas
dorsals84110843dorsals
doula65717773do_ula_
doumas95314813do_umas
douras75016723do_uras
ferula93011173ferula_
ferulae10309603ferulae
ferules103112723ferules
fibulas12228563fibulas
formals123312893formals
formula1246293formula_
formulae1345983formulae
forums114611843foru_ms
fouls87221433fo_ul_s
gorals76917653goral_s
gorillas946373gorillas
goulash1164273go_ulash
hollas94616903ho_llas
hooplas1239203hooplas
horas86333103hor__as
hulas84920883__hulas
jocular1637303jocular
jorums15408093joru_ms
jouals1338923jo_uals
joules134116823jo_ules
koalas104011663ko_alas
kolas94822233ko__las
koras95927113kor__as
kormas124511233kor_mas
koruna1035483koruna_
ligulas8329173ligulas
lobular936663lobular
lobules92510813lobules
locular938953locular
locules92812603locules
loculus9296973loculus
loumas84812333lo_umas
macula103013673macula_
maculae113412863maculae
macular113011943macular
macules114015133macules
manilas93915873manilas
manuals9311213manuals
maquilas1944033maquilas
maracas11313773maracas
maras75443293mar__as
marbles114516653marbles
marinas93519383marinas
markas124717003mar_kas
markkas12356083markkas
marls75535163mar_l_s
marsalas1038253marsalas
masalas9312053masalas
mauls76524953m_aul_s
mazumas2034623mazumas
medullas1144513medullas
medusas1036213medusas
merles85322763mer_les
merls77423903mer_l_s
mezuzas1743233mezuzas
miauls8178713miaul_s
mirzas1738183mir_zas
misrules1039383misrules
mizunas1843693mizunas
moas65545343mo___as
mobiles112813123mobiles
mochas13310663mo_chas
mochilas1544953mochilas
modals93914453modal_s
models94216353model_s
modulate1138593modulate
modulates1238053modulates
module93011033modul_e
moduli9267963modul_i
modulo9256983modul_o
modus85417203modu__s
moghuls1343613moghul_s
mogul8310213mogul__
moguled1135933moguled
mohels115011323mohel_s
mohurs1135933mohu_rs
moils76125753mo_il_s
mola66035633mo__la_
molal75120343mo__lal
molar75223093mo__lar
molars85517323mo__lars
molds85324833mo__lds
moles74747923mo__les
mollah11319453mo_llah
mollahs12328283mo_llahs
molls75129783mo__lls
mols65948573mo__l_s
molts76032093mo__lts
mommas94110653mo_mmas
momus96116113momu__s
momuses1159263momuses
monas74732153mo__nas
moola75117033mo_ola_
moolah11409193mo_olah
moolahs12347383mo_olahs
mools76027173mo_ol_s
mora66641273mor__a_
morae75831193mor__ae
moral75533433mor__al
morale85220553moral_e
moralise10314913moralise
moralism12312363moralism
moralist10316663moralist
morally12411493morally
morass84614503mor_ass
moray105423793mor__ay
morays114613883mor_ays
morceau1145573morceau
moreens939963moreens
morel75729093morel__
morelle91210803morelle
morelles10710493morelles
morello9117793morello
morellos10136953morellos
mores76249643mor__es
morgan9311373mor_gan
morgans10310123morgans
morgens10310463morgens
morgues1038273morgues
morions94014643morions
morns75527443mor__ns
morons84919543mor_ons
morphias1546843morphias
morphos14159083morphos
morphs13149433mor_phs
morris83814733mor_ris
morros83714673mor_ros
morrows12318723morrows
mors65950063mor___s
morsels94112653morsels
mortal84616853mor_tal
mortar83812043mor_tar
mortars93411523mortars
morts75533563mor__ts
motels83616893motel_s
motiles93317433motiles
mottles93415803mottles
moues75732843mo_u_es
moulage1037903mo_ulage
moulages1138053mo_ulages
mould86015753mo_ul_d
mouldy12437413mo_uldy
moulin8313283mo_ulin
moulins9312703mo_ulins
moult74728723mo_ul_t
mounds93915133mo_unds
mounts84115073mo_unts
mourns84111013mo_urns
mouses85531423mo_uses
mouths115214533mo_uths
moviolas1344513moviolas
moxas145014393mo__xas
mules75034293m__ules
mullas84215933m_ullas
mulls75124153m__ulls
murals84016763mural_s
muras75329583m__uras
murras84916013mur_ras
murrhas12286173murrhas
mutuals937123mutuals
mutular936643mutular
mutules9311843mutules
myricas1436753myricas
myrtles1235733myrtles
nebulas957583nebulas
neurulas844833neurulas
nodular876703nodular
nodules8269703nodules
norias65518203nor_ias
normals92510903normals
ocular8610133_ocular
oculars948363_oculars
oculus8178393_oculus
ollas54218283_o_llas
ooralis7312553ooralis
orals55826483_oral_s
orcas75918623_or_cas
orles55326213_or_les
ovular946833_ovular
ovules938223_ovules
paruras9310533paruras
popular11319563popular
portals94015563portals
poults84613483po_ults
pyrolas1239863pyrolas
radulas839583radulas
ranulas7311773ranulas
rorquals1773173rorquals
rules55234253__rules
scopulas1265483scopulas
soras55041013sor__as
sorels63921163sorel_s
sorus54527583soru__s
souls55127363so_ul_s
spirulas10207203spirulas
sporular1065223sporular
sporules1037703sporules
strumas9419833strumas
tolas54532773to__las
toras55540373tor__as
tortas64918253tor_tas
torus54329763toru__s
trulls64110283_trulls
uvulas946523_uvulas
verglas1137813verglas
worlds10568733wor_lds
zonula1537223zonula_
zonulae1645963zonulae
zonular1656493zonular
zonules1647793zonules
zorillas1745483zorillas
zorils153810883zoril_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 Filter1786911340270.420425454.8
2DLD Change Limit1340272706.75019855.9
3Display Results2702700.0932903.2
 (SQL Overall)1786912707.26324602.9
 
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.