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

207 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
loggias935678(None) 
loggia8457051loggia_
doggies103613022doggies
leggins9259472leggins
loggats9286452loggats
loggers94616132loggers
loggets9378912loggets
loggie84011992loggi_e
loggier93811142loggier
loggiest103011012loggiest
logging103316802logging
loggings11398232loggings
loggish12258722loggish
logia68116602lo_gia_
logics95711122lo_gics
logins77820642lo_gins
longies82916552longies
luggies93011212luggies
moggies113111722moggies
noggins9288452noggins
aggies83515513_aggies
agrias74315393_agrias
baggies113814853baggies
biggies113813523biggies
biggins113410693biggins
bloggers12397403bloggers
blogging13369013blogging
bloggings14264263bloggings
boccias13307193boccias
boggier113711583boggier
boggiest123110933boggiest
bogging123615753bogging
boggish14238653boggish
boggles113411823boggles
bogies94724313bo_gies
boogies103719013boogies
bougies103715183bougies
buggies114613813buggies
cloggers12437283cloggers
cloggier1244253cloggier
cloggiest1334723cloggiest
cloggily1543243cloggily
clogging13368503clogging
cobias104014973co_bias
codeias103911213codeias
cogging123513713cogging
congas94417033cong_as
congius103210073congius
corgis9314403corgi_s
daggas937973dagg_as
doggers104413433doggers
doggie93910893doggi_e
doggier103810943doggier
doggiest113410523doggiest
dogging113312693dogging
doggish13237533doggish
dogies85022253do_gies
dogmas105011243do_gmas
dongas84914613dong_as
eulogias946553eulo_gias
floggers13387863floggers
flogging14329173flogging
floggings15314123floggings
foggers124112013foggers
foggier12349913foggier
foggiest13249653foggiest
foggily1535053foggily
fogging133513733fogging
fogies104118063fo_gies
gigas75415583__gigas
glias64618493__glias
gloggs935033glogg__s
glorias81610313glo_rias
goggles103510793goggles
haggis11209513haggi_s
hoagies112811993hoagies
hoggers124512483hoggers
hoggets12498323hoggets
hogging133112803hogging
hoggish15247593hoggish
hoggs107212463hogg__s
hogties112813993hogties
hongies112716473hongies
jaggies163311083jaggies
joggers164110693joggers
jogging173211233jogging
joggings18264633joggings
joggles164410413joggles
laggers94216243laggers
lagging103316733lagging
laggings11298403laggings
lagunas8156823lagunas
lamias85020613l_amias
laogais845813laogai_s
latrias71913213latrias
leggier9368233leggier
leggiest10308233leggiest
leggin8268593leggi_n
legging103912643legging
leggings11316193leggings
legits71313003l_egits
lignins84010493lignins
ligulas8329163ligulas
lingas75116563ling_as
lithias1038823lithias
lobbies113612463lobbies
lobelias1047203lobelias
lochia1158313lochia_
lochial1257083lochial
lodgers95113833lodgers
lodges86820143lodg_es
lodging103110813lodging
lodgings11336243lodgings
logan68123283lo_g_an
logania847833logania_
logans76319063lo_gans
loges66534203lo_g_es
logged96622943logg_ed
logger86420003logg_er
loggy105714193logg__y
logic88217833lo_gi_c
logical1038513logical
logician1145223logician
logicians1244173logicians
logier75015733lo_gier
logiest82515543lo_giest
logily1039833lo_gily
login66025003lo_gi_n
logion76013723lo_gion
logions86211293logions
logjam1635363lo_gjam
logjams1743583logjams
logogram1275233logogram
logograms1354693logograms
logoi69715943logoi__
logons79818173lo_gons
logos67225333lo_g_os
logs57343113lo_g__s
logway1335913lo_gway
logways1434513logways
loids66220703lo__ids
loins56728423lo__ins
lollies73116923lollies
lomeins969473lomeins
longan75612363long_an
longans84510813longans
longers84819533longers
longes75925573long_es
longing93915783longing
longings10408563longings
longish11229093longish
longs65527063long__s
longways1543873longways
loobies93814103loobies
loofas9429833lo_ofas
looies65025833lo_oies
loonies73919543loonies
lories64933043lo_ries
loris55329153lo_ri_s
lorries74518343lorries
lotas55926303lo__tas
loughs105014773loug_hs
louies64525103lo_uies
louis57322323lo_ui_s
loumas84812333lo_umas
luggers93713483luggers
luggie8318903luggi_e
lugging104114353lugging
lungis77113023lungi_s
moggie103210103moggi_e
mogging123311493mogging
muggins11248073muggins
noggin8288883noggi_n
nogging103612723nogging
noggings11285743noggings
noggs75811183nogg__s
noogies82814583noogies
norias65518183no_rias
obias76116853_o_bias
ohias84415563_o_hias
ologies8615023ologies
orgiac934993_orgiac
orgiast837463_orgiast
orgies72316093_orgies
piggies113813483piggies
piggins113010473piggins
pogies94123543po_gies
pogonias1148513pogonias
pongids11347413pongids
porgies103017003porgies
raggies93214733raggies
sloggers10418783sloggers
slogging113410493slogging
soggier93410883soggier
soggiest102711643soggiest
soggily1235953soggily
togas67823003to_g_as
togging103512743togging
toggles93710973toggles
tongas74315513tong_as
veggies1237553veggies
vigias104110893_vigias
woggish15276673woggish
yogas96615603yo_g_as
yogins105114103yo_gins
yogis95617743yo_gi_s
zoysias1943843zoysias

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.1531167915.0
2DLD Change Limit1340272077.34618244.9
3Display Results2072070.0762723.7
 (SQL Overall)1786912077.57523589.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.