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

351 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
morgans1031012(None) 
morgan9311371morgan_
morgens10310461morgens
organs7912911_organs
bogans95714812bo_gans
brogans1049662brogans
corbans11313172corbans
gorgons938852gorgons
hogans105914312ho_gans
jordans1566832jordans
kurgans12145652kurgans
logans76319062lo_gans
longans84510812longans
lorans65117602lor_ans
margays1337492margays
margins103815192margins
moans74624372mo__ans
morals85324632mor_als
moras76438772mor_a_s
morass84614492mor_ass
morays114613882mor_ays
mordant10312402mordant
mordants1137142mordants
moreens939962moreens
morgen9312202morgen_
morgues1038272morgues
morions94014642morions
morns75527442mor__ns
morons84919542mor_ons
mortals93914002mortals
mortars93411522mortars
organ6915392_organ_
organa789212_organa
origans839972_origans
aortas65417783aorta_s
argals75517713_argals
argons75018203_argons
bargains1178643bargains
bogan87519003bo_gan_
borages103917163borages
borals86721913bor_als
borane84620213bor_ane
boranes93720403bor_anes
boras75938303bor_a_s
boreas85421733borea_s
boreens9310403boreens
borons85520543bor_ons
brans75437433_br_ans
brogan9311043brogan_
burans85019303bur_ans
cogons96818113co_gons
coigns94410063coig_ns
congas94417033conga_s
corals85325143cor_als
corban10314693corban_
cordons104415763cordons
corgis9314413corg_is
corns76034763cor__ns
coronas93916913coronas
corrals93713853corrals
corsacs1139013corsacs
cortins92421333cortins
cotans81317923co_tans
cougars1038443cougars
courlans10117613courlans
currans9310613currans
dolmans10479683dolmans
dongas84914613donga_s
dormant102814373dormant
dormins10311273dormins
dorsals84110843dorsals
durians839573durians
firmans12238523firmans
forages114217283forages
forams115115913for_ams
forays124813003for_ays
forgat104018583forga_t
forgave1435853forgave
forgers115218183forgers
forges105024263forg_es
forgets113813793forgets
forging124114723forging
forgings13287703forgings
forgoes11311353forgoes
forgone1139343forgone
formals123312893formals
formant123416003formant
formants13269953formants
formats123113573formats
fourgons1234833fourgons
furans94515953fur_ans
germans1079473germans
gobans94412043go_bans
gorals76917653gor_als
gorgers94813643gorgers
gorges85321893gorg_es
gorgets94711783gorgets
gorging102611363gorging
gorgon8310243gorgon_
gorhens1137183gorhens
gormand1157453gormand
gormands1266563gormands
gossans836783gossans
gowans105512293go_wans
grans64832543_gr_ans
groans74815063_groans
hogan97817703ho_gan_
honans94814503ho_nans
horahs126313873hor_ahs
horas86333103hor_a_s
horns86125333hor__ns
jargons1558203jargons
jorams154810533jor_ams
jordan1468063jordan_
koans95818623ko__ans
koras95927113kor_a_s
korats105416063kor_ats
kormas124511233korma_s
korunas1135443korunas
kurgan11126783kurgan_
lagans75717783_lagans
ligans76817733_ligans
loans56026463lo__ans
lochans1248833lochans
logan68123283lo_gan_
loggats9286453loggats
logins77820643lo_gins
logons79818173lo_gons
longan75612363longan_
loran55925093lor_an_
lorgnons943993lorgnons
lungans8399053lungans
lurdans837073lurdans
magians10310753magians
mangas94122923manga_s
mannans93611523mannans
mans66354553m___ans
maras75443283mar_a_s
margarins1248293margarins
margay12310593marga_y
margent10316693margent
margents11410133margents
marges94525713marg_es
margin94016843margin_
marinas93519383marinas
markas124717003marka_s
marlins93420473marlins
maroons92615553maroons
marrams11310123marrams
marrano939423marrano
marranos1038423marranos
marrons93216973marrons
martens93714953martens
martians103111613martians
martins93322063martins
means75831233m__eans
medians103214213medians
megass9219443m_egass
merganser1242843merganser
mergees104411233mergees
mergers103813423mergers
merges94122483merg_es
merging112711763merging
merlins93015813merlins
merlons93311273merlons
merman10513863merman_
messans92710463messans
migrant10314313migrant
migrants1138183migrants
minyans1237263minyans
mirages102213533mirages
mirins83918903mir_ins
mirzas1738183mirza_s
moan65832023mo__an_
moas65545343mo__a_s
moats75827643mo__ats
mobcaps1543463mobcaps
mochas13310663mocha_s
modals93914453mo_dals
moderns1037963moderns
moggies113111723moggies
mogging123311493mogging
mogs75439333mo_g__s
moguls948553mo_guls
molars85517323mo_lars
molas75132093mo_la_s
mollahs12328283mollahs
mommas94110653momma_s
monads94515303mo_nads
monas74732153mo_na_s
monerans10310343monerans
mongers104217273mongers
mongoes103415713mongoes
mongols103310823mongols
mongos94318623mong_os
mons68152263mo___ns
montane91313623montane
montanes101114523montanes
moolahs12347383moolahs
moolas83615593moola_s
moons75331003mo__ons
moorages1139053moorages
moorhens1344853moorhens
moorland1144683moorland
moorlands1244203moorlands
mora66641273mor_a__
morae75831193mor_a_e
moraine9314573moraine
moraines10314363moraines
moral75533433mor_a_l
morale85220553mor_ale
morales93619403morales
morassy12495043mor_assy
moray105423793mor_a_y
mordancy1644193mordancy
mordent10313993mordent
mordents1138813mordents
moreen8313343moreen_
morels84820013mor_els
mores76249643mor__es
morganite1247423morganite
morganites1346723morganites
morgue938113morg_ue
morion86217733morion_
morn66237563mor__n_
morning103215043morning
mornings11297923mornings
moron76925423mor_on_
morphins1538653morphins
morphos14159083morphos
morphs13149433mor_phs
morrions1077673morrions
morris83814733mor_ris
morros83714673mor_ros
morrows12318723morrows
mors65950063mor___s
morsels94112653morsels
mortal84616853morta_l
mortar83812043morta_r
mortary12369043mortary
mortgage1244213mortgage
mortgages1344023mortgages
mortmains1344493mortmains
morts75533563mor__ts
morulas959713morulas
motions94215003motions
moulins9312703moulins
mourns84111013mo_urns
moutons9410313moutons
moxas145014393mo_xa_s
muggars11316643muggars
muggins11248073muggins
murals84016753mur_als
muras75329563mur_a_s
mureins9310733mureins
murrains1036853murrains
murras84916003murra_s
myriads1334353myriads
noggins9288453noggins
nonfans1037533nonfans
nongays11176533nongays
norias65518203noria_s
norland837163norland
norlands936443norlands
normals92510903normals
nougats8427413nougats
oceans81211003_oceans
octans81411143_octans
ogams84112683_o_gams
omegas936973omega_s
orals55826483_or_als
orang65119943_or_ang
orangs74116033_or_angs
orcas75918623_orca_s
orcins83313433_orcins
ordains879653_ordains
oreads73915773_oreads
oregano846253_oregano
oreganos945553_oreganos
organdy1254573_organdy
organic1038313_organic
organics1146383_organics
organise939323_organise
organism1148393_organism
organist9411543_organist
organon845913_organon
organons945583_organons
organum1045343_organum
organums1143883_organums
organza1793463_organza
organzas1853263_organzas
orgasm966303_orgasm
orgasms1054293_orgasms
orgeats838353_orgeats
orgies72316093_orgies
orgone71110913_orgone
orgones81010793_orgones
origan7310693_origan_
origins8310463_origins
orlons6411013_orlons
orphans1237773_orphans
orpins83614163_orpins
pagans95717923_pagans
parians93519733parians
partans94418283partans
popguns1234023popguns
porgies103017003porgies
porns75527343por__ns
portals94015563portals
prolans9314273prolans
pyrans11411063pyr_ans
roans54926443__roans
romans84620243ro_mans
rowans95715343ro_wans
sarans64224433sar_ans
shorans102812413shor_ans
slogans8407983slogans
solans64122493so_lans
soldans83210403soldans
somans84619303so_mans
soras55041013sor_a_s
sorghos11327603sorghos
sorgos74514663sorg_os
sorns55028423sor__ns
soudans8309353soudans
sovrans1036483sovrans
sowans94215893so_wans
sporrans1045523sporrans
tarpans92513533tarpans
tartans72615823tartans
tarzans16329923tarzans
togas67823003to_ga_s
tolans64319273to_lans
tomans85419133to_mans
tongas74315523tonga_s
torahs95115643tor_ahs
toras55540373tor_a_s
tortas64918253torta_s
toucans937583toucans
trans54933043_tr_ans
trogons83410723trogons
turbans939563turbans
vegans103910853_vegans
virgas1048883virga_s
virgins1137863virgins
wangans1149503wangans
wigans104511703_wigans
womans114613653wo_mans
worsens104610263worsens
yogas96615603yo_ga_s
yogins105114103yo_gins

Search took 10 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.1401276364.3
2DLD Change Limit1340273518.86015127.2
3Display Results3513510.2501404.0
 (SQL Overall)1786913519.25019317.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.