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

71 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
daycares145480(None) 
daycare1355091daycare_
daymares1445331daymares
daymare1375632daymare_
decares102818532d_ecares
acarus8312193_a_carus
acres76327763_a_c_res
alcades101011473_alcades
arcades101113193_arcades
ascared10399523_ascared
ascaris93613323_ascaris
baccaras1446913baccaras
barwares13610093barwares
bayards13379683bay_ards
calcars11312653calcar_s
carcases12313093carcases
cares77369183___cares
carfares13310323carfares
cascades13128553cascades
cascaras1237703cascaras
caviares1337993caviares
claywares1743463claywares
cycases1437533_cycases
daces85030683da_c__es
dacites101114593da_cites
dackers143417043da_ckers
damages11511283da_mages
damars93815003da_mar_s
dammars12308193dammar_s
dancers103413093dancer_s
dances95120653danc__es
darbars10510093darbar_s
dares66146703d___ares
dastards10278083dastards
dasyures1254153dasyures
dataries9314033da_taries
dayflies1534463dayflies
daysides1335963daysides
daystars1243903daystar_s
daytimes1434483daytimes
dayworks1945563dayworks
decades113615513d_ecades
decanes103118913d_ecanes
decare93919153d_ecare_
deciares11510633deciares
declares11611313declares
dekares122710873d_ekares
discards1238913discards
discases112014503discases
dogcarts1243883dogcarts
drayages1344513dray_ages
dryades12395633dry_ades
facades1339033fa_cades
fanfares1436773fanfares
gaydars1235803gaydar_s
haylages1536013haylages
haywards1845873haywards
haywires1744043haywires
jacales16310323ja_cales
keycards1843063keycards
lascars979013lascar_s
mascaras1237693mascaras
nacres85614453na_c_res
oatcakes1445543oatcakes
pancakes1637073pancakes
saccades13137253saccades
scares85033003__scares
vacates12312833va_cates
warfares1436683warfares
wayfarer1742923wayfarer
wayfarers1842623wayfarers

Search took 7 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.423422437.4
2DLD Change Limit146162716.15623743.0
3Display Results71710.0302366.7
 (SQL Overall)178691716.60927037.5
 
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.