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

69 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
cabbagy174401(None) 
cabbage1446981cabbage
cabbagey1843211cabbagey
abbacy1536622_abbacy
cabbaged1644382cabbaged
cabbages1537202cabbages
cabbala1367182cabbala
cabby145314562cabb__y
garbagy1444242garbagy
abba810522653_abba__
abbas95918643_abba_s
abbey125714933_abb_ey
ambage11510603_ambage
ambary134010543_ambary
cabal95222153ca_ba_l
cabala103516913ca_bala
cabals104020153ca_bals
cabana103913563ca_bana
cabbaging1744093cabbaging
cabbalah1763793cabbalah
cabbalas1467373cabbalas
cabbed135416263cabb_ed
cabbie122913353cabb_ie
cabbies133115163cabbies
cabbing143613153cabbing
cabman123812503cabma_n
cabotage1345223cabotage
cadgy125210783ca__dgy
cagy106321993c___agy
calvary1537183calvary
canary11314693ca_nary
capably1639253capably
carbamyl1743103carbamyl
carbarn1139453carbarn
carbaryl1544423carbaryl
carboy134914183carb_oy
carnage10311743carnage
cartage10312593cartage
casbah1337903casba_h
casbahs1436463casbahs
cobby145516413cobb__y
crabbily1744343crabbily
crabby15346753crabb__y
cribbage1542973cribbage
crybaby1941933crybaby
cubage1178273c_ubage
cubby145212123cubb__y
gabbard1336553gabbard
gabbart1248883gabbart
gabby135512953gabb__y
garbage1138053garbage
garbagey1543373garbagey
gasbag1035413gasbag_
gasbags1135473gasbags
kabbala1584613kabbala
rabbity14266303rabbity
ragbag1045463ragbag_
ragbags1135113ragbags
ratbag956563ratbag_
ratbags1035763ratbags
sabbat10314713sabba_t
sabbath1445393sabbath
sabbats1138633sabbats
scabbard1544203scabbard
scabbily1763943scabbily
scabby1535503scabb__y
tabby125213893tabb__y
wabbly16348363wabb_ly
yabby15389753yabb__y

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.406440125.6
2DLD Change Limit134027696.92319359.7
3Display Results69690.0302300.0
 (SQL Overall)178691697.35924282.0
 
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.