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

116 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
dapsones113838(None) 
dapsone1038461dapsone_
capstones1347372capstones
daemones11209162daemones
daimones11208802daimones
damsons1038012damson_s
daphnes13327682dap_hnes
depones103717092dep_ones
diaphones1547442diaphones
agones75719863_a_gones
ambones11312683_ambones
ancones93116343_ancones
apposes11511473_apposes
aproned10311503_aproned
aprons8316993_apron_s
apses76823913_aps__es
apsides103911303_apsides
arsines73518813_arsines
arsons63917213_arson_s
atones65225773_a_tones
axones134614513_a_xones
cajones163311333ca_jones
calzones1948763calzones
canzones1939153canzones
capons104119503cap_on_s
capotes11314643cap_otes
capsizes2147203capsizes
capsomer1445773capsomer
capsomers1544753capsomers
capstone1237653capstone_
capsules1236623capsules
cassenes103611293cassenes
cassines103116613cassines
dacrons103211033dacron_s
dadoes85616533da_do_es
daemons10269233daemon_s
dagoes85714603da_go_es
dahoons1137753dahoon_s
daikons12186693daikon_s
daimons10249323daimon_s
daises74318983dais__es
daisies84217093dais_ies
daltons8310403dalton_s
damson938063damson__
daphne12237013dap_hne_
dapples1238993dap_ples
darioles9710693darioles
dashes106124983da_s_hes
dassies84418663da_ssies
dauphines1544343dauphines
dawsonites1442533dawsonites
daysides1335963daysides
debones103315113d_ebones
deplanes11311213deplanes
deplores1139533deplores
depone93616553dep_one_
deponed113712873dep_oned
deposes103117213dep_oses
depsides1238503depsides
desponds1246243desponds
diapasons1243203diapason_s
diaphone1447103diaphone_
diaphonies1645833diaphonies
diaspores1266543diaspores
diploes101111493diplo_es
diplonts1146473diplonts
diploses111110323diploses
dipoles101013753dip_oles
dipsades1246493dipsades
dipsos95310053dipso__s
disposes11313823disposes
doblones1136763doblones
dobsons1036203dobson_s
doggones1135713doggones
dripstones1343933dripstones
drones75023433d__rones
dropsondes1452673dropsondes
duopsonies1352523duopsonies
duotones937643duotones
earphones1448393earphones
earstones948523earstones
fatsoes10379423fatso_es
hambones1539673hambones
haplonts1345773haplonts
haploses1338853haploses
haptenes133810823haptenes
hipbones1546023hipbones
impones112712253imp_ones
jawbones20134853jawbones
lactones10311243lactones
ladrones92710973ladrones
lapses85217693laps__es
lassoes74613853lasso_es
madrones112912283madrones
masoned1039803ma_soned
masons83916513ma_son_s
padrones112711043padrones
papooses1248053papooses
parsons93516873parson_s
peones83821043__peones
pepsines1239883pepsines
peptones12311033peptones
phones114121213__phones
pones74547043__p_ones
ramsons939563ramson_s
rapines95120863rap_ines
rhapsodes1543183rhapsodes
sapotes9313943sap_otes
saprobes1237033saprobes
sawbones13126643sawbones
soapstones1243893soapstones
sones55444143___sones
spadones1137253spadones
tapholes1339623tapholes
topstones1147013topstones
yapons114411773yap_on_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 Filter1786911461620.656272394.8
2DLD Change Limit1461621167.17020385.2
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.87222699.6
 
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.