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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

82 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
gawsy1245909(None) 
gassy95514021gassy
gawky16569991gawky
away108024222_away
awny105919302_awny
awry107619682_awry
bassy1012917102bassy
bawdy147513282bawdy
bawty135614102bawty
caws96036102caws_
daisy95915312daisy
daws86638242daws_
easy76224492ea_sy
fawny144711712fawny
gabby135512942gabby
gabs76740422gabs_
gaby107123192ga_by
gads67843382gads_
gaes56348032gaes_
gags66441062gags_
gaily95020972gaily
gally95026172gally
gals57946502gals_
gamay116419102gamay
gamey115320552gamey
gammy135514892gammy
gams76648882gams_
gamy105427532ga_my
gappy136212032gappy
gaps76042972gaps_
gapy106320912ga_py
gars55750742gars_
gas48870252ga_s_
gash86833022ga_sh
gasp76227332ga_sp
gast56052562ga_st
gats56753442gats_
gaudy106611462gaudy
gauss65613452gauss
gauzy18489212gauzy
gawk126716692gaw_k
gawks136811632gawks
gawp107618632gaw_p
gawps115911012gawps
gawsie1038462gawsie
gay76856492ga__y
gayly124513092gayly
gays87338022gays_
gipsy11579542gipsy
glassy10527752glassy
gnaws96311142gnaws_
goosy96018882goosy
gorsy95915782gorsy
grassy10619092grassy
gussy95314322gussy
gutsy96412842gutsy
gypsy14636992gypsy
haws106439442haws_
hawse116015122hawse
jaws145027292jaws_
lawny115912012lawny
laws76441682laws_
massy104518962massy
maws96437132maws_
newsy11489392newsy
palsy105417462palsy
pansy105717972pansy
patsy105717202patsy
pawky173810152pawky
paws96038182paws_
rawly115115832rawly
raws75238212raws_
sassy85813812sassy
saws75839482saws_
tansy84514932tansy
tawny114713652tawny
taws75641592taws_
tawse85616502tawse
vaws105527322vaws_
waws106834902waws_
yawey14458272yawey
yaws105531212yaws_

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit53800821.47036598.6
3Display Results82820.0302733.3
 (SQL Overall)178691821.593112172.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.