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

146 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
demesne103557(None) 
demesnes1137081demesnes
defense1137502defense
demean9510562demean_
demeaned1237282demeaned
demeans1039712demeans
dement93825142deme_nt
demerge11168022demerge
demes86032692demes__
demise94618322demis_e
mesne75116292__mesne
bemean10410683bemean_
bemeaned1335783bemeaned
bemeans1148733bemeans
bemuse1038943bemus_e
celeste949653celeste
cement103321663ceme_nt
cymene1377393cyme_ne
dames85435853dames__
debase94014473debas_e
debone93714783de_bone
decane93818873de_cane
decease1049523decease
deceive1337813deceive
decent94023703dece_nt
decern91310953decern_
decerned1237263decerned
decerns10119053decerns
decline103716613decline
deeming113913123deeming
deems85421773deems__
deemster1175713deemster
deepen9339193de_epen
dees56356633de_es__
defence1339893defence
defend113910493defe_nd
defensed1336223defensed
defenses1237913defenses
define104718143de_fine
defuse105712723defus_e
dehisce13104273dehisce
dejeuner1682933dejeuner
dekeing13358353dekeing
dekes105224453dekes__
delaine8314793delaine
deleave1147723deleave
deleing93313953deleing
deles65139253deles__
delete73620703dele_te
demand104314253dem_and
demast9517063demas_t
demasted1238763demasted
demasts1089223demasts
deme76536283dem___e
demeanor1143833demeanor
demented12311273demented
dements103016623dements
demerged13157603demerged
demerger12127373demerger
demerges12129503demerges
demerit10314993demerit
demersal1145263demersal
demeton1037683demeton
demetons1137623demetons
demies94825803demies__
demilune1144423demilune
demised113613683demised
demises103719563demises
demising122012523demising
demister11310223demister
demode104013463dem_ode
demoing11311753demoing
demon86520313dem_on_
demons94917723dem_ons
demos86022993demos__
demoses103815823demoses
demote94817803dem_ote
demount1049743demount
dempster1355773dempster
demure9311533dem_ure
dene56643413d__e_ne
denes65639723denes__
dense65923503de_ns_e
dentine83320243dentine
depend103510923depe_nd
deplane10311413deplane
depone93616553de_pone
depose94215763depos_e
deserve11108703deserve
destine83719953destine
detent73624483dete_nt
detente83313603detente
deterge9118463deterge
detest74122843detes_t
detested10279623detested
detester9239683detester
detests83711743detests
devein1039143devein_
deveined1336673deveined
deveins1138803deveins
devest104418703deves_t
devested13239133devested
devests114410473devests
devise104215753devis_e
devisee113812713devisee
dexes135224513dexes__
diene65720133d_ie_ne
dimes85833043dimes__
domaine10610503domaine
domes85735563domes__
domine92918253dom_ine
doyenne1143883doyenne
emend86214893_eme_nd
emerge91510463_emerge
emes65434663_emes__
emeses86114963_emeses
emesis84712623_emesis
emetine9712943_emetine
emeute838533_emeute
esne47018793___esne
eterne6311723_eterne
femes105626223femes__
geese64316003ge_es_e
hemes105031083hemes__
hemline12311073hemline
immense1135293immense
kermesse14303483kermesse
ketene106613003kete_ne
memes94927703memes__
mense75025633__mense
mesnes85216213__mesnes
nemeses948663nemeses
nemesis937373nemesis
remend95216553reme_nd
remerge10148923remerge
remise84221953remis_e
retene69224273rete_ne
sememe10129983seme_me
semen75724103seme_n_
semens84616963seme_ns
semes75731583semes__
semester1038903semester
serene63522353sere_ne
someone938813someone
tumesce1144563tumesce
venene92912523vene_ne

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.1561145455.1
2DLD Change Limit1340271465.97022450.1
3Display Results1461460.0602433.3
 (SQL Overall)1786911466.18628886.4
 
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.