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 “gabbard” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

154 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
gabbard133655(None) 
gabbards1445751gabbards
gabbart1248881gabbart
aboard9312612_aboard
gabbarts1344062gabbarts
gabbed125216892gabb_ed
gabber114916602gabber_
gabbers124612832gabbers
gabbled134112452gabbled
gabbro11114952gabb_ro
garboard1247242garboard
scabbard1544202scabbard
tabard9313332ta_bard
abba810522653_abba__
abbacy1536623_abbacy
abbas95918643_abba_s
abfarad1344223_abfarad
absurd935903_absurd
afeard1058263_afeard
ambari103012173_ambari
ambary134010543_ambary
award97118043_a_ward
babbled113612863babbled
bard75648863___bard
bastard103012423bastard
bayard124411663ba_yard
beard86024963__beard
board85523003__board
bombard1437333bombard
cabbage1446983cabbage
cabbaged1644383cabbaged
cabbagy1744013cabbagy
cabbala1367183cabbala
cabbed135416263cabb_ed
canard9314763ca_nard
carbarn1139453carbarn
catbird1235243catbird
dabbed124416143dabb_ed
dabber114816963dabber_
dabbers123813213dabbers
dabbled133712073dabbled
darbar959953darbar_
darbars10510093darbars
dastard9279703dastard
debeard1137353debeard
fabber134814113fabber_
fatbird1344033fatbird
gabbier12379633gabbier
gabbing133512033gabbing
gabble113815723gabb_le
gabbler124013303gabbler
gabblers134110083gabblers
gabbles124415413gabbles
gabbroid1452763gabbroid
gabbros12124653gabbros
gabby135512953gabb__y
gabled105518453ga_bled
galliard10125753galliard
gamba106018513gamba__
gambade1336383gambade
gambado1344973gambado
gambas115817513gamba_s
gambir11509773gambir_
gambirs12359083gambirs
gambled134112163gambled
garbage1138053garbage
garbagy1444243garbagy
garbed104815663garb_ed
garbled114512803garbled
garboards1346363garboards
garland948703garland
gasbag1035413gasba_g
gasbags1135473gasbags
gaydar1135503gaydar_
gaydars1235803gaydars
gazar154612983ga_zar_
gazars164811553ga_zars
gibbed124512353gibb_ed
gibber114112863gibber_
gibbered1444303gibbered
gibbers124710983gibbers
gizzard17114203gizzard
goalward1343493goalward
gobbed124613883gobb_ed
gobbled134010253gobbled
goliard936073goliard
grabbed13368643grabb_ed
grabber12389763grabber_
grabbers13337883grabbers
grabbled14327373grabbled
graybeard1641923graybeard
guard74415543g__uard
guisard954203guisard
gurnard944773gurnard
haggard13377183haggard
halberd1336053halberd
halyard1476973halyard
hatband1346823hatband
hayward1736413hayward
hazard1938403ha_zard
inboard1037063inboard
jabbed184213483jabb_ed
jabber173713643jabber_
jabbered2034433jabbered
jabbers183610583jabbers
jaybird2043123jaybird
kabar114815553ka_bar_
kabars124513953ka_bars
kabbala1584613kabbala
labara83712893la_bara
laggard10347623laggard
laniard868523laniard
lanyard1167293lanyard
lapboard1355783lapboard
larboard1157663larboard
mallard10310273mallard
mansard1049313mansard
manward1349093manward
maybird1543993maybird
mazard1838763ma_zard
mazzard1844463mazzard
nabbed115113613nabb_ed
nabber104913543nabber_
nabbers113710463nabbers
onboard1046503onboard
rabbled123514423rabbled
reboard10310763reboard
ribband1245583ribband
rubboard1343983rubboard
sabbat10314713sabba_t
sabbath1445393sabbath
sabbats1138633sabbats
sabbed114518083sabb_ed
saggard10358953saggard
sambaed1238303sambaed
sambar103914163sambar_
sambars115113843sambars
scabbards1643763scabbards
seaboard1147433seaboard
tabards10310383ta_bards
tabbed114215363tabb_ed
tabbied12297793tabbied
tagboard1245563tagboard
tanbark1337373tanbark
tankard1267263tankard
tanyard1167183tanyard
teaboard1146293teaboard
vanward1456943vanward
vaward13498723va_ward
wabbled153311443wabbled
wayward1736053wayward
yabber136111833yabber_
yabbered1633963yabbered
yabbers14389353yabbers

Search took 11 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 Limit13402715410.39312895.9
3Display Results1541540.1261222.2
 (SQL Overall)17869115410.67216743.9
 
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.