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

113 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
apodoses113665(None) 
apodosis1146581apodosis
acidoses1136772acidoses
aldoses8311202a_ldoses
apoapses1244722apoapses
apocopes1445992apocopes
apodous1037402apodo_us
apoptoses1346442apoptoses
apposes11511472ap_poses
papooses1248052papo_oses
abioses9311493a_bioses
abodes94417513abod__es
acidosis1146143acidosis
adenoses947903adenoses
adiposes1137173adiposes
adobes94411533a__dobes
adonises92611433adonises
adores74420723a__dores
agaroses938823agaroses
agonises92613163agonises
aldose7311093a_ldose_
amidases1136653amidases
amidones11348663amidones
amitoses1039053amitoses
amyloses1347223amyloses
anemoses10159433anemoses
anodes74418763anod__es
anodizes1837963anodizes
anodynes1244443anodynes
apagoges12144693apagoges
apheses12610703ap_heses
aphorises14310003aphorises
apoapsis1244103apoapsis
apocope1346033apocope_
apods86316343apod___s
apogees1037103apo_gees
apologies12311193apologies
apologises1347303apologises
apologs1038593apolo_gs
apologues1245023apologues
apolunes1045293apolunes
apomixes1934853apomixes
apophases1647973apophases
apophyses1946113apophyses
apoptosis1345363apoptosis
apostles1037753apostles
apotheoses1543873apotheoses
appeases1238663appeases
appose10411993ap_pose_
apposed1247853ap_posed
apposer1147483ap_poser
apposers1236283ap_posers
apprises12310963apprises
approves15126833approves
appulses1234893appulses
apses76823913ap___ses
apyrases1337243apyrases
arkoses113910833a_rkoses
arouses74921293aro_uses
atomises103514403atomises
avodires1244123avodires
azotises1737603azotises
azygoses2163313azygoses
cabooses1237863cabo_oses
chooses125717423cho_oses
dodoes85716103_dodo_es
doses65938503___doses
epidotes1147023epidotes
epodes94315563epod__es
eposes84418783ep__oses
exoduses1644803exoduses
gaposises1245523gaposises
gooses75723053_go_oses
haploses1338853hap_loses
iodises83413633_iodises
isodose845373isodose_
looses67328243_lo_oses
lordoses937143lordoses
lotoses73713643_lotoses
nodose738883_nodose_
nooses65623643_no_oses
opposes1149243op_poses
pandores11312453pandores
papoose1147513papo_ose_
pappooses1243993pappooses
paradoses122510253paradoses
pathoses13412773pathoses
pocosen1146833_pocosen
pocosens1255253_pocosens
podites103014733_podites
podsols1056513_podsols
poises84226543_po_ises
poodles103013513_poodles
pooves113914713_po_oves
porose84818743_porose_
poses74642763_p__oses
posoles9314883_posoles
posses85128803_po_sses
pozoles1839063_pozoles
proposes122515973proposes
proses84733473_p_roses
ptoses83514673_p_toses
pyoses114314303_p_yoses
rooses65526233_ro_oses
soroses73117483_soroses
spadones1137253spadones
spodes94817433spod__es
spodosol1142223spodosol
spodosols1242313spodosols
spouses92912813spo_uses
vamooses1345523vamo_oses
vaporises14209453vaporises
zoonoses1746203zoonoses

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.406440125.6
2DLD Change Limit1461621136.76621602.4
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.21824756.3
 
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.