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

108 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
acidoses113677(None) 
acidosis1146141acidosis
abioses9311492abi_oses
acidness1136722acidness
acinose938572acinose_
adiposes1137172adiposes
aldoses8311202a_ldoses
amidases1136652amidases
amidones11348662amidones
amitoses1039052amitoses
apodoses1136652apodoses
abides94719893abid__es
abiosis939373abi_osis
academes1344873academes
acarboses1345083acarboses
accesses1287493accesses
accidies1338043accid_ies
accosts11107993ac_costs
accuses114112193ac_cuses
acerose9310893acerose_
acetones10310033acetones
acetose938843acetose_
achiotes1339003achiotes
acidifies15126453acidifies
acidities12810183acidities
acidnesses1337253acidnesses
acidotic1355983acidotic
acids87121003acid___s
acinous9310933acino_us
acnodes1037823ac_nodes
acridines1247723acridines
acridness1245073acridness
across8312643ac_ros_s
adenoses947903adenoses
adipose1036653adipose_
adiposis1146253adiposis
adobes94411523a__dobes
adores74420713a__dores
agaroses938823agaroses
aides65336603a_id__es
aidless83612073a_idless
aldose7311093a_ldose_
aliases7914493ali_ases
alidades1037003alidades
amidase1036733amidase_
amides95722663amid__es
amidines113010853amidines
amidogen1243913amidogen
amidogens1343653amidogens
amidols10457563amido_ls
amidone10349313amidone_
amitosis1047203amitosis
amyloses1347223amyloses
anemoses10159433anemoses
animuses1037983animuses
anises64826693ani__ses
anisoles81010123anisoles
antidotes1049533antidotes
apodosis1146583apodosis
apposes11511473a_pposes
aridness939223aridness
ariose64818723ari_ose_
ariosos7409853ari_osos
arises65233803ari__ses
arkoses113910833a_rkoses
asides75118873asid__es
avidness1246113avidness
axises134413993axi__ses
azides165113803azid__es
azygoses2163313azygoses
bigoses1039073_bigoses
cabooses1237863cabooses
caddises12329353caddises
calcinoses1445123calcinoses
calloses10313393calloses
caseoses1039293caseoses
chaoses124715123_chaoses
chooses125717423_chooses
choses115825133_c_hoses
citoles9312553_citoles
closes85425593_c_loses
coses76949493_c__oses
didoes85716963_dido_es
doses65938503___doses
ecdyses1333413ec_dyses
epidotes1147023epidotes
halidomes15104863halidomes
halitoses1246603halitoses
hidroses1237903_hidroses
lactoses1039813lac_toses
lordoses937143lordoses
meioses9310833mei_oses
mioses84318853_mi_oses
mitoses9312183_mitoses
moidores1156343moidores
niduses837013_niduses
oxidases1643883oxidases
oxidises1644833oxidises
paradoses122510253paradoses
phimoses1537203phimoses
psiloses1036443psiloses
riboses9310443_riboses
sarcoidoses1452543sarcoidoses
trioses75015653tri_oses
triposes1039973triposes
vaginoses1344143vaginoses
varicoses1446653varicoses
viroses10310533_viroses

Search took 10 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.190940478.9
2DLD Change Limit1461621089.23315830.4
3Display Results1081080.0631714.3
 (SQL Overall)1786911089.48618837.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.