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

120 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
osteoses83903(None) 
osteosis846741osteosis
ostoses71213551ost_oses
hostesses1247172hostesses
orthoses11311132orthoses
osmoses9138122os_moses
osteoids945952osteoids
osteomas1045332osteomas
osteosises1044522osteosises
ostioles839272ostioles
ostosis71310122ost_osis
postposes1348192postposes
stenoses8310442_stenoses
asceses938623asce_ses
asepses946363as_epses
askeses1136463aske_ses
asperses104111673asperses
assesses737383assesses
bathoses13310463bathoses
caseoses1039293caseoses
cosmoses1239703cos_moses
esterases949633esterases
estheses1137783estheses
estrones8313323estrones
estruses838483estruses
ethoses10311763_ethoses
exostoses1655623exost_oses
heteroses12410783heteroses
hostess103210243hoste_s_s
hostessed1344353hostessed
ketoses114912873ket_oses
lostnesses1049303lostnesses
lotoses73713643lot_oses
mestesoes1145323mestesoes
mitoses9312183mit_oses
mostests1036833moste_sts
oasthouses1344973oasthouses
obsesses1036223obsesses
obtests9136233obte_sts
obverses1335803obverses
octettes1045533octettes
oestrones949773oestrones
oestruses946403oestruses
offenses1443833offenses
ogresses938473ogresses
opposes1149243o_pposes
orthosis1148193orthosis
osmoles9138363os_moles
osmose8108003os_mose_
osmosed10134843os_mosed
osmosis976573os_mosis
osseous736053osseo_us
osteitis847013osteitis
osteocytes1553423osteocytes
osteoid848193osteo_id
osteoma945433osteo_ma
osteotomes12134373osteotomes
ostiole739013ostiole_
ostomies10310583ostomies
ostosises946233ostosises
otiose639403o_tiose_
outboxes1737823outboxes
outcomes1239763outcomes
outdoes8313123outdo_es
outfoxes1836743outfoxes
outgoes8312643outgo_es
outhouses12310663outhouses
outloves11249673outloves
outmodes11208963outmodes
outmoves13228173outmoves
outposts1037253outposts
outsoles8813113outsoles
outvotes1137903outvotes
oyesses1037333o_yesses
pathoses13412773pathoses
poetesses1137233poetesses
possesses1046323possesses
postboxes2045243postboxes
postcodes1446153postcodes
postholes14410453postholes
postpones1348833postpones
postpose1247653postpose_
postposed1445303postposed
proteoses112211013proteoses
psiloses1036443psiloses
ptoses83514673_pt_oses
saroses73619333_saroses
seises64026713_s_eises
senses63923943_s_enses
sepses84515883_s_epses
setose65114773_setose_
soleuses838073soleuses
someones1039063someones
sorboses1038523sorboses
soroses73117483_soroses
speises93813933_speises
spenses92913573_spenses
stases64225563_st_ases
steeves103410903_steeves
steles63725663_ste_les
stenosed946343_stenosed
stenosis847993_stenosis
steppes113110693_steppes
steres63929533_ste_res
stokes104821793_st_okes
stoles63927673_st_oles
stones65130033_st_ones
stooges83611483_stooges
stopes84525893_st_opes
stores65533663_st_ores
stoss54316343_st_os_s
stoves93818923_st_oves
stresses81112493_stresses
strobes93813263_strobes
strokes114316323_strokes
sycoses1249133_sycoses
teases65426273__teases
tenses64722553__tenses
tsetses785453ts_etses
vitesses1136333vitesses

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.423422437.4
2DLD Change Limit1461621207.22020244.0
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.68923239.8
 
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.