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 “discovers” 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
discovers153815(None) 
discover1439561discover_
discovert1548791discovert
discovery1845271discovery
codiscovers1952122codiscovers
disclosers1375192disclosers
discolors1246592discolors
discovered1765882discovered
discoverer1674812discoverer
discoverers1773462discoverers
discoveries1745802discoveries
disposers1238372disposers
disprovers16145282disprovers
disrobers1246382disrobers
dissevers1386862dissevers
dissolvers1444642dissolvers
dustcovers1641762dustcovers
rediscovers1752412rediscovers
bedcovers1783563bedcovers
ciscoes113610733cisco_e_s
codiscover1852453codiscover_
covers114627963___covers
decoders122810413d_ecoders
decoyers14287713d_ecoyers
descriers1245693descriers
deservers13107293deservers
desilvers13306083desilvers
dialogers1155163dialogers
dicers94720743di_c__ers
dickers144117663di_c_kers
disablers1255803disablers
disarmers1246943disarmers
disasters1039153disasters
disavowers1743023disavowers
disbowels15113683disbowels
discarders1445043discarders
discases112014503discase_s
discern1038493disc__ern
discerners1345703discerners
discerns1138163disc__erns
discloser1256803discloser_
discloses1249473disclose_s
discoed11312483disco_e_d
discoids1239873disco_ids
discolor1146423discolor_
discolours1343823discolours
disconcert1548263disconcert
disconcerts1655233disconcerts
discord1139993disco__rd
discords1238593disco_rds
discos94915213disco___s
discounters1445753discounters
discounts1287823discounts
discourse1246863disco_urse
discoursers1443593discoursers
discovering1845363discovering
discuses113112863discuse_s
discussers13235193discussers
disfavors1643263disfavors
dishevels1653633dishevels
dishonors1345423dishonors
disinters1039713disinters
dislikers14286423dislikers
disobeys1443683dis_obeys
disorders1146963disorders
disposer11310413disposer_
disposes11313823dispose_s
disprover15137073disprover_
disproves15158513disprove_s
disputers1236613disputers
disrober1147623disrober_
disrobes1139743disrobe_s
dissaves1239413dissave_s
dissever12107653dissever_
dissolver1345623dissolver_
dissolves1346233dissolve_s
distaves12311403distave_s
distomes11314163distome_s
distorters1147163distorters
disyokes1656503disyoke_s
ditchers143610363ditc_hers
divers105024963di___vers
drovers115212643d__rovers
dustcover1541913dustcover_
estovers1136453_estovers
incomers1268593_incomers
isomers9310043_is_omers
misavers1348063mis_avers
miscodes13310423miscode_s
miscolors1345863miscolors
misdoers1137103misdo_ers
misgovern1543063misgovern
misgoverns1652063misgoverns
mismoves1537293mismove_s
misnomers1346183misnomers
passovers14144753passovers
pushovers1743003pushovers
recovers133511123_recovers
rediscover1653163rediscover_
rediscovery2051933rediscovery
scorers94115323__scorers
scoters93313813__scoters
shovers134613003__shovers
slipcovers1741773slipcovers
stovers103713733__stovers
uncovers1336573_uncovers
viscoses1338343viscose_s
wingovers1643553wingovers

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411086.98321286.1
3Display Results1081080.0502160.0
 (SQL Overall)1786911087.46923924.4
 
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.