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

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

108 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
gassy9551402(None) 
bassy1012917101bassy
gawsy12459091gawsy
glassy10527751glassy
grassy10619091grassy
gussy95314321gussy
massy104518961massy
sassy85813811sassy
ashy107717352_ashy
ass37844062_ass_
assay8710282_assay
bass66146782bass_
bassi77019322bassi
bassly114610072bassly
basso76017282basso
bossy105515972bossy
brassy11509232brassy
casky144512682casky
cissy104811072cissy
classy11379042classy
daisy95915312daisy
dashy125612382dashy
easy76224492ea_sy
fussy115613952fussy
gabby135512942gabby
gabs76740422gabs_
gaby107123192ga_by
gads67843382gads_
gaes56348032gaes_
gags66441062gags_
gaily95020972gaily
gally95026172gally
gals57946502gals_
gamay116419102gamay
gamey115320552gamey
gammy135514892gammy
gams76648882gams_
gamy105427532ga_my
gappy136212032gappy
gaps76042972gaps_
gapy106320912ga_py
gars55750742gars_
gas48870252ga_s_
gases65633992gases
gash86833022ga_sh
gasify1336332gasify
gasp76227332ga_sp
gasps85415482gasps
gassed85217632gassed
gasser75017772gasser
gasses75724782gasses
gassily1137812gassily
gast56052562ga_st
gasts66628632gasts
gats56753442gats_
gaudy106611462gaudy
gauss65613452gauss
gauzy18489212gauzy
gawky16569992gawky
gay76856492ga__y
gayly124513092gayly
gays87338022gays_
gesso649602gesso
gipsy11579542gipsy
glass65518132glass_
glossy10549002glossy
goosy96018882goosy
gorsy95915782gorsy
grass66125202grass_
gushy125213122gushy
gusty95119572gusty
gutsy96412842gutsy
gypsy14636992gypsy
hasty115718762hasty
hissy116112122hissy
hussy116812762hussy
kissy125510312kissy
lass47444542lass_
lassi56316852lassi
lasso55015682lasso
lossy85214642lossy
mashy136016502mashy
mass66044932mass_
massa75518922massa
masse75125292masse
messy104913832messy
missy105617562missy
mossy105217062mossy
mussy104117642mussy
nasty85717282nasty
palsy105417462palsy
pansy105717972pansy
pass65239952pass_
passe75525692passe
pasty105725052pasty
patsy105717202patsy
pussy105614842pussy
raspy106511702raspy
sass45035622sass_
sissy85812072sissy
tansy84514932tansy
tass45640572tass_
tasse54821842tasse
tasty84820312tasty
vasty116215922vasty
washy145911842washy
waspy135410992waspy
wussy115810342wussy

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 Limit538001081.32640573.2
3Display Results1081080.0303600.0
 (SQL Overall)1786911081.449123320.2
 
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.