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

134 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
fogdog123422(None) 
fogdogs1333261fogdogs
coydog1335132coydog
dogdom1186362dogdom
fogbow1544782fogbow
fordo97218652fordo_
hotdog1134802hotdog
agog68019003_ag_og
bandog1038723bandog
codon86522853co_don
cogon89120903cog_on
cohog117813043co_hog
colog86619933co_log
condo85322593condo_
condom114215363condom
condor94616973condor
condos94322333condos
cordon95017293cordon
coydogs1434493coydogs
dodo66024913do_do_
dodos75819393do_dos
dog57449753___dog
dogdoms1295423dogdoms
dogedom1244663dogedom
doggo84410703doggo_
dogleg936323dogleg
doodoo8108893doodoo
eggnog941973eggnog
fado87226463f_ado_
fados95620733f_ados
faggot1139053faggot
fagot9323403fag_ot
fandom122110893fandom
fido87726393f_ido_
fidos95819053f_idos
firedog1244473firedog
flog85523893f__log
fodder114712113fodder
fodgel1136403fodgel
foetor939563foetor
fog76945563f___og
fogbows1643853fogbows
fogey125617873fog_ey
fogeys13509263fogeys
foggage1334113foggage
fogged125518373fogged
fogger114414783fogger
fogging133513733fogging
foggy136714543fog_gy
foghorn1445433foghorn
fogie96719003fog_ie
fogies104118063fogies
fogs87035003fog__s
fogy115923183fog__y
foison948933foison
fold86528943fold__
folded114212793folded
folder104317543folder
folding123912443folding
foldout1149533foldout
folds95221693fold_s
foldup1233813foldup
folio83820883folio_
folios93915463folios
follow124010353follow
fond86330953fond__
fonded115717043fonded
fonder104120063fonder
fonding123815423fonding
fondle104412943fondle
fondly13299043fondly
fonds95824823fond_s
fondu96013973fond_u
fondue104510493fondue
fondus105210943fondus
food86830573fo__od
foodie104413843foodie
foods95924163food_s
fool75330593fo__ol
foot76248013fo__ot
ford86835493ford__
forded115020393forded
fordid113512053fordid
fording123717043fording
fordoes11311963fordoes
fordoing1357303fordoing
fordone1149383fordone
fords95328183ford_s
foredo10510823foredo_
forego1038903forego
forging124114723forging
forgo94418333forgo_
forgot104318133forgot
formol112910333formol
foxing175012433foxing
frog85624363f__rog
fugio9310923fugio_
fugios1037583fugios
gogo69722833gog_o_
gogos77516523gog_os
grog65923343__grog
gundog935793gundog
hagdon1188283hagdon
hangdog1343133hangdog
hogg96617533hog__g
hoodoo10109983hoodoo
hotdogs1234453hotdogs
koodoo11107773koodoo
lapdog1034443lapdog
logion76013723logion
logo57931763log_o_
logoi69715943log_oi
logon615922313log_on
logos67225333log_os
mondo85721233mondo_
mondos95217333mondos
nogg65115943nog__g
odor55718093_o_dor
ogdoad943523_ogdoad
ordo54622353_ordo_
ordos65216203_ordos
pogrom1138593pogrom
rondo65218373rondo_
rondos74616733rondos
seadog838743seadog
sodom8814913so_dom
soldo67116563soldo_
sordor7310213sordor
sundog837613sundog
tondo69718683tondo_
tondos75115923tondos
vodou939343vo_dou
voodoo10127533voodoo
voudon1035873voudon

Search took 5 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.1261418182.5
2DLD Change Limit1127161344.71623900.8
3Display Results1341340.0334060.6
 (SQL Overall)1786911344.87536654.6
 
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.