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

137 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
discover143956(None) 
discovers1538151discovers
discovert1548791discovert
discovery1845271discovery
codiscover1852452codiscover
discloser1256802discloser
discoed11312482disco_ed
discolor1146422discolor
discovered1765882discovered
discoverer1674812discoverer
disposer11310412disposer
disprover15137072disprover
disrober1147622disrober
dissever12107652dissever
dissolver1345622dissolver
dustcover1541912dustcover
rediscover1653162rediscover
bedcover1663563bedcover
ciscoes113610733cisco_es
codiscovers1952133codiscovers
cover105430773___cover
decoder113712293d_ecoder
decoyer13348683d_ecoyer
descrier1157623descrier
deserver12118383deserver
desilver12286503desilver
dialoger1056083dialoger
dicer85426423di_c__er
dicier94416233di_c_ier
dicker134521403di_c_ker
dickier143512453di_ckier
dictier103411863di_ctier
disabler1147913disabler
disarmer1138033disarmer
disaster949943disaster
disavower1643473disavower
disbowel14115213disbowel
discarder1346753discarder
discase102912863discase_
discased122510853discased
discases112014503discases
disced104914653disc__ed
discern1038493disc__ern
discerner1246943discerner
disclose1148743disclose_
disclosed1347363disclosed
disclosers1375193disclosers
discloses1249473discloses
disco85616073disco___
discoid11311243disco_id
discoids1239873discoids
discoing12511453discoing
discolors1246593discolors
discolour1244173discolour
disconcert1548263disconcert
discord1139993disco_rd
discorded1438133discorded
discords1238593discords
discos94915213disco__s
discount11811313discount
discounter1347023discounter
discourser1344763discourser
discoverers1773463discoverers
discoveries1745803discoveries
discovering1845363discovering
discreet11413183discreet
discuses113112863discuses
discusser12246183discusser
disfavor1542873disfavor
dishevel1564703dishevel
dishier113613403dis_hier
dishonor1255283dishonor
disinter9310673disinter
disliker13358643disliker
dismaler1137903dismaler
disobey1346243dis_obey
disorder1038133disorder
dispose10312763dispose_
disposed12310943disposed
disposers1238373disposers
disposes11313823disposes
disprove14138193disprove_
disproved16147343disproved
disproven15146473disproven
disprovers16145283disprovers
disproves15158513disproves
disputer1137973disputer
disrobe1038993disrobe_
disrobed1238093disrobed
disrobers1246383disrobers
disrobes1139743disrobes
dissave1139413dissave_
dissaved1337313dissaved
dissaves1239413dissaves
dissevers1386863dissevers
dissolve1246103dissolve_
dissolved1445593dissolved
dissolvers1444643dissolvers
dissolves1346233dissolves
distaves12311403distaves
distome10313233distome_
distomes11314163distomes
distorter1048403distorter
disyoke1546233disyoke_
disyoked1745463disyoked
disyokes1656503disyokes
ditcher134012003ditc_her
diver94827803di___ver
drover104614593d__rover
dustcovers1641763dustcovers
incomer1169943_incomer
isomer8310153_is_omer
misaver1249813mis_aver
miscode12310413miscode_
miscoded1437983miscoded
miscodes13310423miscodes
miscolor1245603miscolor
misdoer1048633misdo_er
misgovern1543063misgovern
mismove1437083mismove_
mismoved1635653mismoved
mismoves1537293mismoves
misnomer1247143misnomer
passover13135533passover
pushover1643083pushover
recover124312623_recover
rediscovers1752413rediscovers
rediscovery2051933rediscovery
scorer84818263__scorer
scoter83815483__scoter
shover124515993__shover
slipcover1642093slipcover
stover94115643__stover
uncover1239003_uncover
viscose1237863viscose_
viscoses1338343viscoses
wingover1544303wingover

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.420425454.8
2DLD Change Limit1461621377.16020413.7
3Display Results1371370.0462978.3
 (SQL Overall)1786911377.62623431.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.