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

236 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
loggia845705(None) 
loggias9356781loggias
loggie84011991loggie
logia68116601lo_gia
doggie93910892doggie
leggin8268592leggin
lochia1158312lochia
logania847832logania
logged96622942logged
logger86420002logger
loggier93811142loggier
logging103316802logging
loggish12258722loggish
loggy105714192logg_y
logic88217832lo_gic
login66025002lo_gin
logoi69715942logoi_
luggie8318902luggie
moggie103210102moggie
noggin8288882noggin
aggie73415013_aggie
agria65517143_agria
alodia71112453alo_dia
baggie102912193baggie
biggie103810933biggie
biggin103710603biggin
blogger11448313blogger
blogging13369013blogging
boccia12338793boccia
bogged116019283bogged
boggier113711583boggier
bogging123615753bogging
boggish14238653boggish
boggle104511943boggle
boggy126116073bogg_y
bogie89524103bo_gie
boogie93515993boogie
bougie93613273bougie
clogged12528653clogged
clogger11438803clogger
cloggier1244253cloggier
cloggily1543243cloggily
clogging13368503clogging
cloggy1344873clogg_y
cobia94117513co_bia
codeia94112193codeia
cogged116416613cogged
cogging123513713cogging
conga85419873cong_a
congii957363congii
corgi8316083corgi_
corgis9314413corgis
coria75828323co_ria
dagga839543dagg_a
dogged106017703dogged
dogger95216783dogger
doggier103810943doggier
doggies103613023doggies
dogging113312693dogging
doggish13237533doggish
doggo84410703dogg_o
doggy115214873dogg_y
dogie75222793do_gie
dogma96112463do_gma
donga76718423dong_a
eulogia846663eulo_gia
flogged13528803flogged
flogger12449463flogger
flogging14329173flogging
fogged125518373fogged
fogger114414783fogger
foggier12349913foggier
foggily1535053foggily
fogging133513733fogging
foggy136714543fogg_y
fogie96719003fo_gie
folia83618933fo_lia
giga66720943__giga
glia56423153__glia
glogg837353glogg__
gloggs935033glogg_s
gloria71910543glo_ria
goggle94511573goggle
goggly12337053goggly
gonia64117533go_nia
haggis11209513haggis
hoagie102310013hoagie
hogg96617533hogg__
hogged125817773hogged
hogger114615083hogger
hogget114715763hogget
hogging133112803hogging
hoggish15247593hoggish
hoggs107212463hogg_s
hogtie102711773hogtie
hongi96715873hongi_
jogged166015923jogged
jogger154713163jogger
jogging173211233jogging
joggle154010353joggle
labia75219013l_abia
lagged95520133lagged
lagger85919833lagger
lagging103316733lagging
laguna7127223laguna
lamia75324323l_amia
laogai735983laogai_
laogais845813laogais
latria62313593latria
legged95713093legged
leggier9368233leggier
legging103912643legging
leggins9259473leggins
leggy105210243legg_y
legit61323503l_egit
lignin74911193lignin
ligula7359673ligula
linga66820823ling_a
lingua7509913lingua
lithia939333lithia
lobelia947213lobelia
loca65527683lo__ca
lochial1257083lochial
loci66126283lo_ci_
lodge76520093lodg_e
lodged913815713lodged
lodger86517693lodger
lodges86820153lodges
lodging103110813lodging
log46252683lo_g__
logan68123283lo_gan
logans76319063logans
loge56837193lo_g_e
loges66534203lo_ges
loggats9286453loggats
loggers94616133loggers
loggets9378913loggets
loggiest103011013loggiest
loggings11398233loggings
logical1038513logical
logician1145223logician
logics95711123logics
logier75015733logier
logily1039833logily
logins77820643logins
logion76013723logion
logjam1635363logjam
logo57931763lo_g_o
logogram1275233logogram
logon615922313lo_gon
logons79818173logons
logos67225333lo_gos
logs57343113lo_g_s
logway1335913logway
logy87025783lo_g_y
loid55531493lo__id
loin46838723lo__in
lomein8410203lomein
long56933343long__
longan75612363longan
longe66626463long_e
longed87121373longed
longer75823203longer
longes75925573longes
longies82916553longies
longing93915783longing
longish11229093longish
longly10279603longly
longs65527063long_s
loofa85912813lo_ofa
looie55624243lo_oie
loonie64216453loonie
lorica8310443lorica
loris55329153lo_ris
lota47233503lo__ta
loti46431843lo_ti_
lotic76420673lo_tic
lough95118483loug_h
loughs105014773loughs
louie55023513lo_uie
louis57322323lo_uis
louma76213633lo_uma
lugged94417063lugged
lugger83916553lugger
luggies93011213luggies
lugging104114353lugging
lungi65516053lungi_
lungis77113023lungis
mogged115215393mogged
moggies113111723moggies
mogging123311493mogging
moggy125212163mogg_y
nogg65115943nogg__
nogged95716333nogged
nogging103612723nogging
noggins9288453noggins
noggs75811183nogg_s
noogie73612313noogie
noria55722183no_ria
obia67923113_o_bia
ohia75719363_o_hia
oidia6314953_oidia
oogonia846483oogonia
orgiac934993_orgiac
orgic8311823_orgic
ossia53710403_ossia
ostia52315583_ostia
piggie103210773piggie
piggin103111093piggin
podia8415283po_dia
pogonia1048933pogonia
pongid104111583pongid
slogged104910473slogged
slogger94310483slogger
slogging113410493slogging
sogged95518523sogged
soggier93410883soggier
soggily1235953soggily
soggy105413903sogg_y
toga57027413to_g_a
togged95117513togged
togging103512743togging
toggle83810873toggle
tonga65619693tong_a
veggie1136303veggie
vigia94813273_vigia
vogie95116663vo_gie
woggish15276673woggish
yoga87418053yo_g_a
yogi86120423yo_gi_
yogic116114933yo_gic
yogin98317743yo_gin
yogis95617743yo_gis
zoaria1548383zoaria
zoecia1735553zoecia
zoysia1844163zoysia

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162364.65624208.8
3Display Results2362360.0603933.3
 (SQL Overall)1786912365.10634996.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.