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 “oospores” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
oospores104953(None) 
oospore939011oospore_
zoospores2046211zoospores
exospores1845482exospores
gosports1185912gosports
oosperms1243792oosperms
oospheres1456632oospheres
oosporic1245062oosporic
spores84726612__spores
zoospore1945632zoospore_
apospories1446183apospories
ascospores1454033ascospores
aspires9612043_aspires
booklores1545073booklores
bookstores1644083bookstores
compares143816433compares
comperes143217973comperes
comports143411983comports
composes145017113composes
compotes144716513compotes
condores113315643condores
conspires1358483conspires
cosmoses1239703cosmoses
cowpokes1944573cowpokes
cowpoxes2244513cowpoxes
diaspores1266543diaspores
disports111111113disports
disposes11313823disposes
endospores1345303endospores
exospore1745233exospore_
gonopores1246523gonopores
gosport101010283gospor_t
homospories1855213homospories
hoopoes121212483hoopo_es
hospices1587633hospices
inspires1037623inspires
isospories1244743isospories
moidores1156343moidores
moonports1344403moonports
mopokes1536693mo_pokes
noospheres1545143noospheres
obscures1245513obscures
offshores1842353offshores
onshore10310013onshore_
oosperm1134883oosper_m
oosphere1355993oosphere
opposes1149243_opposes
osmoles9138363_osmoles
osmoses9138123_osmoses
osprey1134883_osp_rey
ospreys1233143_osp_reys
ostoses71213553_ostoses
otoscopes1346513otoscopes
outports1048273outports
outscores11178463outscores
outsnores9176773outsnores
phosphores2078423phosphores
polypores1648003polypores
pores75849033___pores
posoles9314883pos_oles
postpones1348833postpones
postposes1348193postposes
postures10313783postures
rescores105415693rescores
respires10311903respires
restores85222993restores
roscoes9310923rosco_es
scores84725923__scores
shores94830413__shores
snores64324323__snores
sopors85215203so_por_s
sores55454283__s_ores
spares84834553__spares
spires84628113__spires
splores91910953__splores
spodes94817433__spodes
spokes124417213__spokes
spore75428593__spore_
spored94821793__spored
sports84619183__sports
stores65533663__stores
suspires1038203suspires
torpors939383torpor_s
tsores65113663_ts_ores
tussores8316533tussores
woodlores1345163woodlores
zoochores2345953zoochores
zoosperms2242613zoosperms
zoosporic2253363zoosporic
zygospores2562283zygospores

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.1561145455.1
2DLD Change Limit146162906.97020970.2
3Display Results90900.0303000.0
 (SQL Overall)178691907.15624970.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.