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

122 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
dognaps113439(None) 
dognap1035341dognap_
cognacs1256042cognacs
dogears937512dogears
dogmas105011242dogma_s
dognaped1343492dognaped
dognaper1243692dognaper
dognapers1343072dognapers
donas65926472do_na_s
dongas84914612donga_s
donnas75511322donna_s
bogans95714813bog_ans
catnaps1197033catnaps
cognac1157273cogna_c
cognate10312203cognate
cognates11311583cognates
cogways1634633cogways
congas94417033conga_s
daggas937973dagga_s
daps77239163d___aps
degas75119163deg_a_s
denars74621433d_enars
dewlaps1334663dewlaps
digraph14146643digraph
digraphs15105753digraphs
dinars75417563d_inars
doats65224883do__ats
doblas93812293dobla_s
dobras94811913dobra_s
dogbane1135653dogbane
dogbanes1245433dogbanes
dogcart1148043dogcart
dogcarts1243883dogcarts
dogdoms1295423dogdoms
dogear838193dogea_r
doges75630163dog__es
dogeys115510663dog_eys
dogface1454053dogface
dogfaces1554143dogfaces
doggers104413433doggers
doggies103613023doggies
dogies85022253dog_ies
doglegs1034783doglegs
dogma96112463dogma__
dogmata1145143dogmata
dognaping1443183dognaping
dognapped1642143dognapped
dognapper1542433dognapper
dognappers1642053dognappers
dogs66440153dog___s
dogvane1243853dogvane
dogvanes1344303dogvanes
doings84913183doin_gs
dollars83311023dollars
dollops10287963dollops
dolmans10479683dolmans
dolmas95213043dolma_s
dona55529633do_na__
donate73619503do_nate
donates83217223do_nates
donees74519493do_nees
donga76718423donga__
dongles93212873dongles
dongs76525813do_n_gs
donna66215033donna__
donnees84210363donnees
donors75115793do_nors
dons56048703do_n__s
donuts7410583do_nuts
doodads1035093doodads
doowops1363943doowops
dopants1038433dopants
dopas85019063do_pa_s
dorps85419223do__rps
dorsals84110843dorsals
dossals8379293dossals
doulas75114993doula_s
doumas95314813douma_s
dourahs11487253dourahs
douras75016723doura_s
downers113912773downers
downs94918573down__s
dunams937833d_unams
gaps76042973__g_aps
gnars66718853__gnars
gnats65217713__gnats
gnaws96311143__gnaws
gonads84511733go_nads
hogans105914313hog_ans
hognuts1134183hognuts
honans94814503ho_nans
kidnaps1453323kidnaps
knaps115511173__knaps
lignans8398853lignans
logans76319063log_ans
loggats9286453loggats
logjams1743583logjams
logways1434513logways
longans84510813longans
mobcaps1543463mobcaps
monads94515303mo_nads
monas74732153mo_na_s
naps66238583___naps
nonas55126653no_na_s
nongays11176533nongays
odograph1577333odograph
odographs1667343odographs
ogams84112683_og_ams
oghams1245853_oghams
petnaps1145033petnaps
pogonips1344383pogonips
schnaps1443703schnaps
shnaps1148083_shnaps
signals8359163signals
snaps74719563__snaps
soaps75120713so__aps
sonars64818973so_nars
toecaps1135553toecaps
togas67823003tog_a_s
tongas74315523tonga_s
unsnaps935423unsnaps
yogas96615603yog_a_s

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.406440125.6
2DLD Change Limit1340271227.37318178.1
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.82522835.9
 
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.