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

60 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
cupcake174395(None) 
cupcakes1843711cupcakes
cuplike1537212cuplike
uncake122813522_uncake
uptake1236962_uptake
ashcake1663373ashcake
cake105439963___cake
capmaker1855203capmaker
carcase11312743carcase
cascade12118603cascade
chicane1489553chicane
cicale10314503c_icale
comake144413423c_omake
concave1439373concave
corncake1645263corncake
crake114823523c__rake
cubage1178273cu_bage
cuke105824983cu___ke
culpae10389263culpa_e
cuneate9311723cuneate
cuppa11398523cuppa__
cuppas12458593cuppa_s
cuprite1159683cuprite
cupulae11347853cupulae
cupulate122810033cupulate
cupule103410723cup_ule
curare84916953cu_rare
curate85226243cu_rate
curiae84518373curia_e
curtate9312643curtate
cuspate1138233cuspate
cuttage10318343cuttage
furcate12310453furcate
hoecake1645203hoecake
hotcake1644543hotcake
muscae10410673musca_e
nutcase975763nutcase
oatcake1345363oatcake
outbake13310773outbake
outtake11310793outtake
pancake1536673pancake
pupae96515643pup_a_e
pupate104213123pup_ate
quake184114643qu__ake
reuptake1443463reuptake
spake114322743_sp_ake
splake1259783_splake
sulcate9314423sulcate
teacake1335453teacake
uncage93014873_uncage
uncaked143514353_uncaked
uncakes133012743_uncakes
uncase83817433_uncase
unmake122811213_unmake
upcast102710093_upcast
update93810293_update
upgaze1833543_upgaze
uprate83916543_uprate
upscale11136323_upscale
uptakes1336593_uptakes

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.406440125.6
2DLD Change Limit134027606.14021828.5
3Display Results60600.0302000.0
 (SQL Overall)178691606.57627173.2
 
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.