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

112 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
distastes103963(None) 
distaste939941distaste_
distasted1137961distasted
diastases1047072diastas_es
dictates11311382dicta_tes
disaster949942dis_aster
disasters1039152dis_asters
discases112014502discas_es
diseases92415812diseas_es
dismasted1346832dismasted
dismasts1137512dismast_s
disrates91118152disra_tes
distances12311652distances
distaves12311402dista_ves
bistate9313823bista_te_
cineastes1165563cineastes
cistuses1038283cistus_es
diabases1137223diabas_es
diamantes1296263diamantes
diastase946603diastas_e_
diastem10318043di__astem
diastems11226523di__astems
diaster82813313di__aster
diasters92913183di__asters
dicasts1078703di_cast_s
dictate10311663dicta_te_
dictated1239203dicta_ted
dietaries10410663dietaries
diktats1235623dikta_t_s
dilates83220663di_la_tes
dioptases1245903dioptas_es
disables11410903dis_ables
discanted1339333discanted
discants112912023discant_s
discase102912863discas_e_
discased122510853discas_ed
discuses113112863discus_es
discusses12268253discusses
disease83213843diseas_e_
diseased103011713diseas_ed
diseuses93112763diseus_es
disgusted1246123disgusted
disgusts1045653disgust_s
diskettes1446573diskettes
dismantles1344333dismantles
dismast10311233dismast__
dismisses1245503dismisses
disparted1338853disparted
disparts11109953dispart_s
disposes11313823dispos_es
disputes1139653dis_putes
disrate81418523disra_te_
disrated10915573disra_ted
dissaves1239413dissa_ves
disses75225963dis__s_es
distaffs1565083dista_ffs
distained1139603distained
distains9413603dista_ins
distance11311853distance_
distanced1348573distanced
distant83519953distant__
distantly1346393distantly
distantness1254333distantness
distasteful1551693distasteful
distasting1248023distasting
distomes11314163dist_omes
distorted1139373distorted
distorter1048403distorter
distorters1147163distorters
distorts91112353distort_s
distracted1448873distracted
distracts1249283distract_s
distraite10611483distraite_
distresses1148853distresses
distrusted1246293distrusted
distrusts1046523distrust_s
disunites1088673disunites
disuses84015413dis_us_es
disvalues1344503disvalues
dittanies1045733dittanies
ecstasies1145053ecstasies
epistases1146323epistas_es
epistasies1244393epistasies
estates74520183_esta_tes
eustasies946023eustasies
fistnotes1243783fistnotes
gestates93213733gesta_tes
impastes12238193_impastes
instates81615833insta_tes
miscasts1238353miscast_s
misdates111113633misda_tes
miseases102614343miseas_es
mismates121114563misma_tes
misrates101318243misra_tes
misstates11710633missta_tes
mistakes141213413mista_kes
nictates1039593nicta_tes
pistaches1646673pistaches
posthastes1546273posthastes
pretastes11119423pretastes
restates83423433resta_tes
retastes82212903_retastes
stactes91914633__stactes
stases64225563__stas_es
stashes103916173__stashes
states64337083__sta_tes
tastes64126423___tastes
testates83615453testa_tes
uintaites9136333uintaites
unstates81314993unsta_tes
upstates10189643upsta_tes
wiseasses1244043wiseasses

Search took 10 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.420425454.8
2DLD Change Limit1486411128.72017046.0
3Display Results1121120.0631777.8
 (SQL Overall)1786911129.20319416.6
 
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.