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

85 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
daycare135509(None) 
daycares1454801daycares
daymare1375631daymare
daymares1445332daymares
decare93919152d_ecare
acari75020283_a_cari
acre67330773_a_c_re
aglare7312423_aglare
alcade91111513_alcade
arcade91013643_arcade
arcane81216743_arcane
ascared10399523_ascared
aware86420023_a_ware
baccae12119703bacca_e
baccara1347143baccara
baccate131011263baccate
barware12610703barware
bayard124411663bay_ard
calcar10312753calcar_
calcars11312653calcars
calycate1537893calycate
carcase11312743carcase
care66968373___care
carfare12310073carfare
cascade12118603cascade
cascara1138313cascara
caviare1238373caviare
clayware1643933clayware
dace76934923da_c__e
dacite91115883da_cite
dacker134920753da_cker
damage10410773da_mage
damar84117733da_mar_
damars93814993da_mars
dammar11438903dammar_
dammars12308193dammars
dance85223133danc__e
dancer94817613dancer_
dancers103413093dancers
darbar959953darbar_
darbars10510093darbars
dare55848863d___are
dastard9279703dastard
dasyure1153823dasyure
datary10310243da_tary
dayside1236173dayside
daystar1143443daystar_
daystars1243903daystars
daytime1344783daytime
daywork1845653daywork
decade104216163d_ecade
decane93818873d_ecane
decares102818533d_ecares
deciare10710663deciare
declare10411223declare
dekare112811563d_ekare
discard11310213discard
discase102912863discase
dogcart1148043dogcart
drayage1234423dray_age
facade1238803fa_cade
falcate12311613falcate
fanfare1336673fanfare
gaydar1135503gaydar_
gaydars1235803gaydars
haylage1436443haylage
hayward1736413hayward
haywire1644743haywire
keycard1743663keycard
lascar868573lascar_
lascars979013lascars
macabre1335223ma_cabre
mascara1138023mascara
nacre75715363na_c_re
oatcake1345363oatcake
pancake1536673pancake
saccade12107033saccade
saccate111311763saccate
scare75334463__scare
tartare73012683tartare
vacate11314553va_cate
warfare1336733warfare
wayfarer1742923wayfarer
wayward1736053wayward
yare75636943__y_are

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 Filter1786911340270.420425454.8
2DLD Change Limit134027855.72023431.3
3Display Results85850.0302833.3
 (SQL Overall)178691856.17028961.3
 
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.