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 “dogvane” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
dogvane124385(None) 
dogbane1135651dogbane
dogvanes1344301dogvanes
dogbanes1245432dogbanes
dogface1454052dogface
doggone1035682doggone
hogmane1336342hogmane
bogan87519003bog_an_
bogans95714813bog_ans
borane84620213bo_rane
bovine11712433bo_vine
bugbane1255863bugbane
cognate10312203cognate
convene123314323convene
corvine122113643corvine
couvade1335063couvade
cowbane1437673cowbane
decane93818873d_ecane
degage92711383deg_age
degame102713183deg_ame
deglaze1835583deglaze
degrade10229903degrade
deplane10311413deplane
dioxane1565423dioxane
divan96114843d_ivan_
divans104612393d_ivans
divine103514463d_ivine
dockage1535723dockage
dogcart1148043dogcart
doge66233803dog___e
dogear838193dogea_r
dogeared1145793dogeared
dogears937513dogears
dogfaces1554143dogfaces
doggie93910893dog_gie
dogging113312693dogging
doggoned1243883doggoned
doggoner1143873doggoner
doggones1135713doggones
doghanged1642343doghanged
dogie75222793dog__ie
doglike13207453doglike
dogma96112463dogma__
dogmas105011243dogma_s
dogmata1145143dogmata
dognap1035343dogna_p
dognaped1343493dognaped
dognaper1243693dognaper
dognaps1134393dognaps
dolman95312403dolman_
dolmans10479683dolmans
domaine10610503domaine
domine92918253do_mine
donate73619503do_nate
done55747913do___ne
donne65520463do__nne
dopant9316133do_pant
dormant102814373dormant
dosage82810003do_sage
dotage82711613do_tage
dourine8311453dourine
dove85131563do_v__e
doven94718553do_ven_
dovened12389063do_vened
dovens104413903do_vens
doyenne1143883doyenne
foggage1334113foggage
gane55145303__g_ane
hogan97817703hog_an_
hogans105914313hog_ans
hogmanes1446783hogmanes
logan68123283log_an_
logans76319063log_ans
lovage1037353lo_vage
montane91313623montane
novae85913123no_va_e
octane81411633_octane
ovate84214393_o_vate
ovine86316643_o_vine
pavane114113443_pavane
solvate102710213solvate
soutane7312063soutane
togae67020113tog_a_e
togate74515683tog_ate
tolane64316583to_lane
vane75534693___vane
volvate13317993volvate

Search took 7 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.403443402.0
2DLD Change Limit134027875.84622926.3
3Display Results87870.0302900.0
 (SQL Overall)178691876.27928458.5
 
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.