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

54 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
garbagey154337(None) 
garbage1138051garbage_
garbages1238181garbages
garbagy1444241garbag_y
cabbagey1843212cabbagey
garage8314512gar_age_
garaged1039252gar_aged
garages9314112gar_ages
garganey1344882garganey
ambage11510603_ambage_
ambages1269623_ambages
barbate11314543barbate_
barrage10710843barrage_
barraged1297683barraged
barrages11711083barrages
cabbage1446983cabbage_
cabbaged1644383cabbaged
cabbages1537203cabbages
cabbagy1744013cabbag_y
carnage10311743carnage_
carnages11312213carnages
cartage10312593cartage_
cartages11313313cartages
gambade1336383gambade_
gambades1435863gambades
gamboge1335583gamboge_
gamboges1435653gamboges
garbageman1671263garbageman
garbagemen1671773garbagemen
garbanzo2042583garbanzo
garbed104815663garb__ed
garble94118453garb_le_
garbled114512803garb_led
garbler104012563garb_ler
garbles104016923garb_les
garganeys1442613garganeys
garget84327273gar__get
gargety12388043gar__gety
garvey13127873gar__vey
gasbag1035413gasbag__
gasbags1135473gasbag_s
gavage1137193ga_vage_
gavages1237683ga_vages
grapey126012303g_r_apey
herbage1337003herbage_
herbaged1554523herbaged
herbages1437093herbages
parbake1538353parbake_
parbaked1735503parbaked
parbakes1638343parbakes
warpage1336403warpage_
warpages1437053warpages
yardage1235733yardage_
yardages1336203yardages

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 Filter1786911461620.470380193.6
2DLD Change Limit146162546.87321266.1
3Display Results54540.0331636.4
 (SQL Overall)178691547.37624226.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.