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 “daytimes” 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
daytimes143448(None) 
daytime1344781daytime_
datives11310072da_tives
dauties83315762dauti_es
dawties113312702dawti_es
daysides1335962daysides
pastimes123611902pastimes
playtimes1644412playtimes
ragtimes1135822ragtimes
wartimes1336962wartimes
actives12311523_actives
airtimes1037503airtimes
animes84719593_a_nimes
anytime1246043anytime_
attires72312953_attires
banties94324763banti_es
baptises1238923baptises
baptizes2136843baptizes
bastiles10313353bastiles
bawties124214313bawti_es
bedtimes1336593bedtimes
betimes115114413_betimes
captives1538623captives
catties94023053catti_es
centimes124012613centimes
dacites101114593da_cites
daddies103414943daddi_es
dailies84219263daili_es
daimen92210573da__imen
dainties9312403dainti_es
dairies84217733dairi_es
daises74318983da__ises
daisies84217093daisi_es
dallies84023193dalli_es
dames85435853da___mes
dandies94121443dandi_es
darbies104216983darbi_es
darkies124015753darki_es
dartles84014133dart_les
dassies84418663dassi_es
dates65639153da_t__es
dative10311813da_tive_
datums936353da_tum_s
dautie72914703dauti_e_
davies105020513da_vi_es
dawtie103011093dawti_e_
daycares1454803daycares
dayflies1534463dayflies
daylilies1343123daylilies
daymares1445333daymares
dayside1236173dayside_
daysmen1335083day_smen
deities82621923deiti_es
delimes10314193d_elimes
dentines93418403dentines
destines93619663destines
dimes85833043d___imes
dirties83119383dirti_es
distomes11314163distomes
ditties83116983ditti_es
downtimes1544513downtimes
doylies114512573doyli_es
dreamtimes1542193dreamtimes
duties74921903d_uti_es
fatties103018203fatti_es
gayeties1236883gayeti_es
halftimes1742883halftimes
hayrides1536883hayrides
haywires1744043haywires
laities7320343laiti_es
latices9313763la_tices
lattices1038383lattices
mantises10317923mantises
mastixes1738253mastixes
mealtimes1345243mealtimes
meantimes1345883meantimes
mistimes12612613mistimes
nasties73520493nasti_es
natives10310823na_tives
ofttimes1343123ofttimes
optimes1148473_optimes
panties94230933panti_es
pantiles103617153pantiles
parties93230863parti_es
pasties94529813pasti_es
pastime114611973pastime_
pastises103616053pastises
patines95225763pa_tines
patties93425143patti_es
paynims1434973paynim_s
playtime1544793playtime_
ragtime1036163ragtime_
ratines75328583ra_tines
ratites74920683ra_tites
retimes95020173_retimes
salties73725773salti_es
saltines82917793saltines
saltires83112433saltires
santims9312603santim_s
satires72617573sa_tires
septimes1238303septimes
stimes85920573__stimes
tatties74120343tatti_es
teatimes1039443teatimes
times75630823___times
uptimes1177553_uptimes
wartime1237743wartime_
waysides1544453waysides

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 Limit1461621086.90621164.5
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.37224239.1
 
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.