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

84 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
garbagy144424(None) 
garbage1138051garbage
garbagey1543371garbagey
cabbagy1744012cabbagy
garage8314512gar_age
garbages1238182garbages
gasbag1035412gasbag_
gasbags1135472gasbags
abbacy1536623_abbacy
airbag956963airbag_
airbags1036293airbags
ambage11510603_ambage
ambary134010543_ambary
ariary94114203_ariary
array86317143_arra_y
barbal104016663barba_l
barbate11314543barbate
barrage10710843barrage
cabbage1446983cabbage
cabbagey1843213cabbagey
carbamyl1743103carbamyl
carbarn1139453carbarn
carbaryl1544423carbaryl
carboy134914183carb_oy
carnage10311743carnage
cartage10312593cartage
darbar959953darba_r
darbars10510093darbars
farrago1144923farrago
gabbard1336553gabbard
gabbart1248883gabbart
gabby135512953ga_b_by
gaby107123193ga_b__y
galago838903ga_lago
galaxy17476313ga_laxy
gamay116419103ga_ma_y
gamba106018513gamba__
gambade1336383gambade
gambado1344973gambado
gambas115817513gamba_s
gamboge1335583gamboge
garaged1039253gar_aged
garages9314113gar_ages
garb75332673garb___
garbanzo2042583garbanzo
garbed104815663garb_ed
garbing113613273garbing
garble94118453garb_le
garbled114512803garbled
garbler104012563garbler
garbles104016923garbles
garboard1247243garboard
garboil1036513garboil
garbology1644393garbology
garbs86321413garb__s
garda7316763garda__
gardai839663garda_i
gardant9314463gardant
garganey1344883garganey
gargety12388043gargety
garland948703garland
garvey13127873gar_vey
gavage1137193ga_vage
grabby14336183grab_by
gramary1355903gramary
granary1157793granary
grapy115416433g_r_apy
gravy125512113g_r_avy
gray85329893g_r_a_y
greasy10419463g_reasy
groggy1234803g_roggy
grungy11345973g_rungy
herbage1337003herbage
marbly134111933marb_ly
margay12310593marga_y
parbake1538353parbake
parlay113713993parla_y
ragbag1045463ragbag_
ragbags1135113ragbags
ratbag956563ratbag_
ratbags1035763ratbags
turbary1236383turbary
warpage1336403warpage
yardage1235733yardage

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.1531167915.0
2DLD Change Limit134027847.54617761.3
3Display Results84840.0332545.5
 (SQL Overall)178691847.73223110.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.