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

131 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
dapsone103846(None) 
dapsones1138381dapsones
capstone1237652capstone
damson938062damson_
damsons1038012damsons
daphne12237012dap_hne
depone93616552dep_one
diaphone1447102diaphone
agone65924553_a_gone
alone55732963_a_lone
ancone83916953_ancone
anyone94612733_anyone
appose10411993_appose
apron7318833_apron_
aproned10311503_aproned
aprons8316993_aprons
apse67725383_aps__e
arsine64021043_arsine
arson55118833_arson_
arsons63917213_arsons
atone56527983_a_tone
axone125918473_a_xone
bausond1044493bausond
calzone1848623calzone
canzone1858813canzone
capon95221873cap_on_
capons104119503cap_ons
capote10315733cap_ote
caprine11314233caprine
capsize2037623capsize
capsomer1445773capsomer
capstones1347373capstones
capsule1137343capsule
cassene93111543cassene
cassine93817283cassine
dacron94310693dacron_
dacrons103211033dacrons
daemon9279593daemon_
daemones11209163daemones
daemons10269233daemons
dahoon1039053dahoon_
dahoons1137753dahoons
daikon11217243daikon_
daikons12186693daikons
daimon9259713daimon_
daimones11208803daimones
daimons10249323daimons
dalton7311273dalton_
daltons8310403daltons
daphnes13327683dap_hnes
dapping133714793dapping
dapple1138853dap_ple
daps77239163daps___
dariole8711163dariole
darksome1544043darksome
dassie74615573da_ssie
dauphine1444493dauphine
dawsonite1342703dawsonite
daylong1233973daylong
dayside1236173dayside
daysmen1335083daysmen
debone93714783d_ebone
deplane10311413deplane
deplore1039483deplore
deponed113712873dep_oned
depones103717093dep_ones
depose94215763dep_ose
depside1138403depside
despond1137513despond
diapason1143623diapason_
diapasons1243203diapasons
diaphones1547443diaphones
diaphony1744123diaphony
diaspore1166063diaspore
diploe9810153diplo_e
diplont10311693diplont
dipole91112853dip_ole
dipso85111553dipso__
dipsos95310053dipso_s
dispose10312763dispose
dobson936593dobson_
dobsons1036203dobsons
doggone1035683doggone
done55747913d___one
dripstone1244153dripstone
drone65324983d__rone
dropsonde1342543dropsonde
drystone1245123drystone
duopsony1442033duopsony
duotone836893duotone
earphone1348253earphone
earstone848603earstone
hambone1439313hambone
haplont12412563haplont
haptene123810933haptene
hipbone1445923hipbone
impone103011863imp_one
jawbone19134443jawbone
lactone9311393lactone
ladrone83611873ladrone
lapse74917683laps__e
lapsing103511163lapsing
madrone102812663madrone
mason74820183ma_son_
masoned1039803ma_soned
masons83916513ma_sons
padrone102512073padrone
papoose1147513papoose
pappose1047413pappose
parson83817903parson_
parsons93516873parsons
pepsine11310603pepsine
peptone11310763peptone
phone105621933__phone
pone65747533__p_one
prone75332623__prone
psoae74411623__psoae
raisonne843813raisonne
ramson8310463ramson_
ramsons939563ramsons
rapine85023083rap_ine
rhapsode1443003rhapsode
sapote8314363sap_ote
saprobe1137333saprobe
soapstone1144143soapstone
sone46649983___sone
taphole1239773taphole
topstone1046883topstone
wagsome1345213wagsome
yapon104613583yap_on_
yapons114411773yap_ons

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.1401276364.3
2DLD Change Limit1340271316.42320866.7
3Display Results1311310.0462847.8
 (SQL Overall)1786911316.60927037.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.