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 “daytime” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
daytime134478(None) 
daytimes1434481daytimes
anytime1246042anytime
dative10311812da_tive
dautie72914702dauti_e
dawtie103011092dawti_e
dayside1236172dayside
pastime114611972pastime
playtime1544792playtime
ragtime1036162ragtime
wartime1237742wartime
active11313743_active
adaptive1445133adaptive
adytum1243733adytum_
airtime948063airtime
anime75423203_a_nime
attire62412383_attire
baptise1139553baptise
baptize2036983baptize
bastile9313913bastile
bawtie113812143bawti_e
bedtime1236973bedtime
betime105914833_betime
bigtime1235753bigtime
captive1438973captive
cattie85221023catti_e
centime114513033centime
dacite91115883da_cite
daimen92210573da__imen
dame77140313da___me
darkie113714013darki_e
darting94020663darting
dartle73714833dart_le
dassie74615573dassi_e
date56443323da_t__e
dating85326483da_ting
datives11310073da_tives
datum8310633da_tum_
datums936353da_tums
dauties83315763dauties
dauting93814763dauting
dawties113312703dawties
dawting123610673dawting
daycare1355093daycare
daylily1434983daylily
daylit10512493dayli_t
daymare1375633daymare
daysides1335963daysides
daysmen1335083day_smen
delime9314043d_elime
dentine83320243dentine
destine83719953destine
dime76237653d___ime
distome10313233distome
downtime1444753downtime
dreamtime1442343dreamtime
ductile1048483ductile
halftime1643313halftime
hayride1437323hayride
haywire1644743haywire
intime81014273_intime
lattice938433lattice
maritime1247383maritime
mealtime1245123mealtime
meantime1245983meantime
mistime11312613mistime
native9613013na_tive
onetime937623onetime
optime1079353_optime
pantie84326473panti_e
pantile93918483pantile
partite9317133partite
pastie85525523pasti_e
pastimes123611903pastimes
patine85328123pa_tine
pattie84020963patti_e
paynim1337363paynim_
paynims1434973paynims
playtimes1644413playtimes
ragtimes1135823ragtimes
ratine65131823ra_tine
ratite65022423ra_tite
raylike14269253raylike
retime85321803_retime
saltie63422433salti_e
saltine75018563saltine
saltire73113043saltire
santimi938793santimi
santims9312603santims
santimu938563santimu
satire63218003sa_tire
septime1138803septime
stime76521803__stime
tactile9310613tactile
tattie64817513tatti_e
teatime9310083teatime
time66235023___time
uptime1067673_uptime
wartimes1336963wartimes
wayside1435183wayside

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 Filter1786911340270.436409841.7
2DLD Change Limit1340271006.81319672.2
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.29524495.0
 
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.