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

124 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
discoids123987(None) 
discoid11311241discoid_
discords1238591discords
cissoids1145362cissoids
desmoids1244972desmoids
diacids1137862diac_ids
diploids1247842diploids
discards1238912discards
discoed11312482discoed_
discoidal1355412discoidal
discoing12511452discoing
discord1139992discord_
discos94915212disco__s
disjoins1647622disjoins
miscoins12311082miscoins
viscoid1337022viscoid_
absconds1343593absconds
biscuits1245133biscuits
cestoids11308273cestoids
ciscoes113610733cisco_es
ciscos104711133cisco__s
cissoid1037343cissoid_
coccoids12176793coccoids
cricoids1347183cricoids
cystoids14306733cystoids
dacoits1079073d_acoits
deltoids1045483deltoids
dermoids1246163dermoids
descends12266983descends
descries11311923descries
desmids1166603des_mids
desmoid1137103desmoid_
despoils1145623despoils
desponds1246243desponds
diacid10310633diac_id_
diamonds12125173diamonds
diapsids1244753diapsids
dickies143416343di_ckies
dicots94915793di_co_ts
diecious1146873diecious
dioxids1655683di_oxids
diploid11310293diploid_
diploidy1544733diploidy
disaccords1652113disaccords
disbands1237353disbands
disbuds11125243dis_buds
discants112912023discants
discard11310213discard_
discases112014503discases
disced104914653disc_ed_
discepts1336743discepts
discerns1138163discerns
disci85815023disc_i__
discing113914593disc_ing
disclaims1444853disclaims
disclike15208653disclike
discloses1249473discloses
disco85616073disco___
discolor1146423discolor
discolors1246593discolors
discomfits1853243discomfits
discorded1438133discorded
discount11811313discount
discounts1287823discounts
discourse1246863discourse
discover1439563discover
discovers1538153discovers
discrowns1544663discrowns
discs85316263disc___s
discus94512113disc__us
discuses113112863discuses
discuss10357953disc_uss
disdains1037913disdains
disjoin1547643disjoi_n
disjoint1649233disjoint
disjoints1745473disjoints
dismiss1038153dis_miss
disowns1136733dis_owns
dispends12308533dispends
disports111111113disports
disposes11313823disposes
disrobes1139743disrobes
disroots948623disroots
distains9413603distains
distends10339823distends
distils83015803dis_tils
distomes11314163distomes
distorts91112353distorts
disulfids14143653disulfids
disyokes1656503disyokes
droids84712583d__roids
fibroids1445843fibroids
fucoids1335663_fucoids
histoid1139823histoid_
lipoids1038233li_poids
mastoids1177873mastoids
miscode12310413misco_de
miscodes13310423miscodes
miscoin11311433miscoi_n
miscooks1645463miscooks
miscopies1549613miscopies
misjoins1736913misjoins
miswords1446603miswords
mucoids1237423_mucoids
muscids12187973musc_ids
percoids1339663percoids
piscos105112593pisco__s
pissoirs1044693pissoirs
placoids1347343placoids
prismoids1443613prismoids
psocids1234863_psocids
ripcords1344073ripcords
sarcoids1137803sarcoids
scincoids1453413scincoids
scolds95011233__scolds
sigmoids1244453sigmoids
sloids73712693__sloids
viroids1137923vi_roids
viscid1237473visc_id_
viscoidal1543173viscoidal
viscoses1338343viscoses
viscous1238833visco_us
xiphoids2144193xiphoids
zincoid1946663zincoid_

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 Limit1461621246.65621959.4
3Display Results1241240.0602066.7
 (SQL Overall)1786911247.13925030.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.