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

118 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
doggone103568(None) 
doggoned1243881doggoned
doggoner1143871doggoner
doggones1135711doggones
dogbane1135652dogbane
doggie93910892dogg_ie
dogging113312692dogging
doggo84410702doggo__
doggonest1244592doggonest
dogvane1243852dogvane
forgone1139342forgone
orgone71110912_orgone
agone65924553__agone
begone9512133_begone
bogging123615753bogging
boggle104511943bogg_le
bygone1256173_bygone
cogging123513713cogging
cogon89120903co_gon_
cogons96818113co_gons
coigne94612193coig_ne
cologne1039363cologne
colone85425003co_lone
compone136517193compone
condone102616293condone
daggle93711903dagg_le
dapsone1038463dapsone
debone93714783d_ebone
depone93616553d_epone
digging113513703digging
doblon938013doblon_
doblones1136763doblones
doblons1037043doblons
dobson936593dobson_
dobsons1036203dobsons
dodge86618133dodg__e
dodging11299063dodging
dogbanes1245433dogbanes
dogdom1186363dogdo_m
dogdoms1295423dogdoms
doge66233803do_g__e
dogface1454053dogface
dogged106017703dogg_ed
dogger95216783dogg_er
doggerel1143453doggerel
doggers104413433doggers
doggery13448263doggery
doggier103810943doggier
doggies103613023doggies
doggish13237533doggish
doggoneder1451083doggoneder
doggoning1343563doggoning
doggrel1033883doggrel
doggy115214873dogg__y
doghouse1345413doghouse
dogie75222793do_g_ie
doglike13207453doglike
dogvanes1344303dogvanes
dogwood1354913dogwood
domaine10610503domaine
domine92918253do_mine
done55747913d___one
dongle83612493dong_le
dongola945473dongola
donjon1436463donjon_
donjons1536733donjons
donne65520463do__nne
dourine8311453dourine
downzone21134273downzone
doyenne1143883doyenne
dragon838843dragon_
dragonet10138953dragonet
dragons938383dragons
drone65324983d__rone
dugong934373d_ugong
duotone836893duotone
epigone1057843epigone
foggage1334113foggage
fogging133513733fogging
fordone1149383fordone
foregone1238583foregone
goggle94511573gogg_le
gone55639043___gone
gorgon8310243gorgon_
gorgons938853gorgons
hogging133112803hogging
hogmane1336343hogmane
hognose11117243hognose
hormone12410503hormone
ionone6313443io_none
isogone8237913isogone
jogging173211233jogging
joggle154010353jogg_le
loggie84011993logg_ie
logging103316803logging
logion76013723logion_
logions86211293logions
logon615922313lo_gon_
logons79818173lo_gons
moggie103210103mogg_ie
mogging123311493mogging
mongoe94214983mongo_e
noggin8288883noggin_
nogging103612723nogging
noggins9288453noggins
ochone11311293_ochone
orgones81010793_orgones
outgone8311463outgone
ozone14310613_o_zone
soigne74310033soig_ne
someone938813someone
togging103512743togging
toggle83810873togg_le
waggon1136393waggon_
waggoned1443253waggoned
waggoner1343423waggoner
waggons1235503waggons
wobegone1443003wobegone

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.436409841.7
2DLD Change Limit1340271186.78319759.3
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.26524596.1
 
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.