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

190 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
loggats928645(None) 
loggets9378911loggets
hoggets12498322hoggets
logans76319062lo_gans
loggers94616132loggers
loggias9356782loggias
logjams1743582logjams
logways1434512logways
longans84510812longans
loquats1645272loquats
lovats939072lo_vats
nougats8427412nougats
beggars11378223beggars
bloats85215763blo__ats
bloggers12397403bloggers
boats75635153bo__ats
bobcats1335993bobcats
bogans95714813bo_gans
bogarts1047743bogarts
boggles113411823boggles
cloggers12437283cloggers
coats75634993co__ats
cognacs1256043cognacs
cognate10312193cognate
cognates11311573cognates
cogways1634633cogways
combats13311683combats
congas94417033conga_s
congrats11311433congrats
cougars1038423cougars
cowpats1437713cowpats
daggas937973dagga_s
doats65224883do__ats
dogcarts1243883dogcarts
dogears937513dogears
doggers104413433doggers
doggies103613023doggies
dogmas105011243dogma_s
dogmata1145143dogmata
dognaps1134393dognaps
dongas84914613donga_s
eggars8398973_eggars
elongate945613elongate
elongates1045383elongates
faggots1234853faggots
floats96816253flo__ats
floggers13387863floggers
foggage1334113foggage
foggages1434213foggages
foggers124112013foggers
forgat104018583forgat_
forgets113813793forgets
formats123113573formats
gats56753443___gats
ghats95818613__ghats
gloats74515423glo__ats
gloggs935033glogg__s
gnats65217713__gnats
goats65527303__goats
goggles103510793goggles
goglets9379783goglets
gorgets94711783gorgets
hogans105914313ho_gans
hoggers124512483hoggers
hogget114715763hogget_
hoggs107212463hogg__s
hognuts1134183hognuts
joggers164110693joggers
joggles164410413joggles
korats105416063ko_rats
lagans75717783l_agans
laggard10347623laggard
laggards11307053laggards
laggers94216243laggers
laogais845813laogais
lariats7615053lariats
lats45962703l___ats
legals73412733l_egals
legate72917453l_egate
legates82917673l_egates
legato72810953l_egato
legatos82711183l_egatos
leggins9259473leggins
legists899593legists
legits71313003l_egits
ligans76817733l_igans
ligate72519243l_igate
ligates82318373l_igates
lights104519913l_ights
lignans8398853lignans
lingams104510173lingams
lingas75116563linga_s
loads65323373lo__ads
loafs85616993lo__afs
loams75619863lo__ams
loans56026463lo__ans
loath84918603lo__ath
lobate82915243lo_bate
locals83714503lo_cals
locate83919843lo_cate
locates93218813lo_cates
lochans1248833lochans
lockets134612203lockets
locusts9277933locusts
lodgers95113833lodgers
lodges86820143lodg_es
lofts85518363lo__fts
logan68123283lo_ga_n
loges66534203lo_g_es
logged96622943logg_ed
logger86420003logg_er
loggia8457053logg_ia
loggie84011993logg_ie
loggier93811143loggier
loggiest103011013loggiest
logging103316803logging
loggings11398233loggings
loggish12258723loggish
loggy105714193logg__y
logia68116603logia__
logics95711123lo_gics
logiest82515543logiest
logins77820643lo_gins
logions86211293logions
logjam1635363logja_m
logograms1354693logograms
logons79818173lo_gons
logos67225333lo_g_os
logs57343113lo_g__s
logway1335913logwa_y
loments93413473loments
longan75612363longa_n
longboats1243923longboats
longers84819533longers
longes75925573long_es
longest84114953longest
longies82916553longies
longs65527063long__s
longways1543873longways
loofahs13364623loofahs
loofas9429833loofa_s
loots55431423lo__ots
loquat1558283loquat_
lorans65117603lo_rans
lotahs9479873lo_tahs
lotas55926303lo_ta_s
lots47652093lo___ts
loughs105014773loug_hs
loumas84812333louma_s
louts56330273lo__uts
lovages1138033lovages
lovat8321043lo_vat_
luggage1043673luggage
luggages1143633luggages
luggers93713483luggers
luggies93011213luggies
lungans8399053lungans
maggots1136553maggots
moats75827643mo__ats
moggies113111723moggies
morgans10310123morgans
muggars11316643muggars
noggins9288453noggins
noggs75811183nogg__s
nongays11176533nongays
nougat74712653nougat_
noughts11478083noughts
nuggets936383nuggets
oats46554213_o__ats
ogams84112683_o_gams
oghams1245853_oghams
ologists939443ologists
organs7912913_organs
orgeats838353orgeats
oughts104710183_oughts
reggaes948883reggaes
rotguts833763rotguts
saggars93610683saggars
seggars9377783seggars
slogans8407983slo_gans
sloggers10418783sloggers
taggants1044923taggants
togas67823003to_ga_s
togate74515683to_gate
toggles93710973toggles
tomcats11127773tomcats
tongas74315513tonga_s
wombats1435893wombats
yogas96615603yo_ga_s
yogurts1142983yogurts

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.1561145455.1
2DLD Change Limit1340271907.18618651.1
3Display Results1901900.0633015.9
 (SQL Overall)1786911907.40524131.1
 
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.