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

272 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
gassily113781(None) 
glassily1235461glassily
grassily1236431grassily
sassily1038721sassily
bassly114610072bass_ly
bossily1237562bossily
brassily1336622brassily
classily1336622classily
easily9313022ea_sily
fussily13267602fussily
gaily95020972ga__ily
gamily123712182ga_mily
gaseity1135112gaseity
gasify1336332ga_sify
gassier83812572gassier
gassing94216332gassing
gassy95514022gass__y
gaudily1236522gaudily
gauzily2034392gauzily
gawkily1834092gawkily
glossily1235092glossily
gossipy1343952gossipy
gushily14257822gushily
gustily113010902gustily
gutsily11267222gutsily
hastily133010662hastily
messily12298812messily
mussily12279772mussily
nastily103011032nastily
tastily103311642tastily
waspily1535512waspily
aerily93017013_aerily
airily93014823_airily
artily92814713_artily
assail6610153_assail_
assails769093_assails
assay8710283_ass_ay
assign736783_assign
assist6314603_assist
assize1538633_assize
assoil688543_assoil_
assoils776663_assoils
baggily1436043baggily
balkily16266693balkily
balmily14216463balmily
basally1237963basally
basely114412313ba_sely
basify1437513ba_sify
basil75122273ba_sil_
basils85717473ba_sils
bassi77019323bassi__
bassist9312743bassist
bassy1012917103bass__y
bastile9313913bastile
bawdily1635803bawdily
bushily15268893bushily
busily112211503_busily
cagily12411563ca_gily
campily1638273campily
cannily1239263cannily
cassia83714763cassi_a
cassias93514343cassias
cassina94113163cassina
cassine93817283cassine
cassino93512433cassino
cassis84818853cassi_s
cattily123210853cattily
classify1644693classify
cosily113613853_cosily
crassly1276653crass_ly
crusily12199093crusily
cushily15257923cushily
daffily1735133daffily
daily95922333da__ily
dandily12279633dandily
dassie74615573dassi_e
dassies84418663dassies
daylily1434983daylily
dossil75110903dossil_
dossils8669773dossils
dressily1246443dressily
duskily15236743duskily
dustily113211523dustily
falsely1336013falsely
falsify1643613falsify
falsity1335903falsity
family143311703fa_mily
fancily1538253fancily
fattily13379463fattily
fishily1637643fishily
fissile10269653fissile
flashily1735473flashily
flossily1434523flossily
fossil9379353fossil_
fossils10379013fossils
fustily133111373fustily
gadfly1434663ga_dfly
gainly1049323ga_inly
gallfly1433523gallfly
gally95026173ga__lly
gamely124711913ga_mely
gangly113911583ga_ngly
garishly1545693garishly
gashing125119233gashing
gaskin113610583gaski_n
gasking134415913gasking
gaskins123510773gaskins
gaslit7513503gasli_t
gasping113714363gasping
gaspingly1644813gaspingly
gassed85217633gass_ed
gasser75017773gass_er
gassers84714633gassers
gasses75724783gass_es
gassiest93212523gassiest
gassings10438403gassings
gasting95022763gasting
gauntly1135333gauntly
gawsie1038463gawsi_e
gawsy12459093gaws__y
gayly124513093ga__yly
gemmily1534603gemmily
ghastly14354563ghastly
ghostly14355103ghostly
giddily1335073giddily
glassie8329493glassi_e
glassier9289083glassier
glassies94012273glassies
glassine9329313glassine
glassing10329973glassing
glassy10527753glass__y
glazily2035383glazily
gluily10308293g_luily
godlily1235343godlily
goofily14105353goofily
gorily10612503g_orily
gossip946433gossi_p
gossipry1441903gossipry
gossips1035903gossips
goutily1137933goutily
grassier9349283grassier
grassing103311973grassing
grassy10619093grass__y
greasily1236233greasily
grimily1336523grimily
grisly104310583gris_ly
gristly11187333gristly
grossly1175983grossly
gussie72910153gussi_e
gussied9267193gussied
gussies82813303gussies
gussy95314323guss__y
hammily1736063hammily
handily143610873handily
happily1745763happily
hardily143310273hardily
harshly1636273harshly
hassel95614213hassel_
hassels104311013hassels
hassium1236133hassium
hassle93711593hass_le
hazily2179063ha_zily
horsily1338843horsily
huskily17236333huskily
jassid1467223jassi_d
jassids1586143jassids
jazzily2533373jazzily
lacily11612763la_cily
lankily1437123lankily
lassi56316853lassi__
lassie64917743lassi_e
lassies74420103lassies
lassis65216703lassi_s
lastly93310873la_stly
lazily1859713la_zily
lousily1038333lousily
lustily103611243lustily
mangily1339753mangily
manlily1238743manlily
massedly1444303massedly
massier93615223massier
massif11412533massi_f
massifs1237743massifs
massing104318023massing
massive12289773massive
massively1744153massively
massy104518963mass__y
mazily20610393ma_zily
missile92815403missile
missilry1344653missilry
mistily122612343mistily
mousily1239393mousily
mushily152410093mushily
muskily16289043muskily
mustily123613633mustily
nasally1057443nasally
nattily103610323nattily
noisily1038403noisily
nosily93712683_nosily
ossify1244973_ossify
passably1537253passably
passel85117003passel_
passels93913023passels
passible1237693passible
passim10410283passi_m
passing104318423passing
passingly1545783passingly
passion9310883passion
passive12239593passive
passively1744613passively
passkey1633563passkey
pastil85018323pastil_
pastils94416173pastils
pawkily1934203pawkily
peskily1635083peskily
possibly1544483possibly
prissily1346693prissily
prosily12611633prosily
pursily1238213pursily
pushily15247983pushily
pussly11407373puss_ly
racily11715173ra_cily
rainily10310433rainily
raisiny10319923raisiny
rashly123410213ra_shly
rassle63813203rass_le
riskily1436413riskily
rosily93914713_rosily
russify1334063russify
rustily103112993rustily
salsify1334703salsify
saltily10310543saltily
sappily1437163sappily
sassaby1244003sassaby
sassier73413233sassier
sassies74719263sassies
sassing84615553sassing
sassy85813813sass__y
saucily1237913saucily
savvily1634323savvily
sessile739523sessile
shily115222013__shily
slily85820033__slily
tackily1637503tackily
tahsil936343tahsil_
tahsils1035053tahsils
tardily11269583tardily
tartily103511573tartily
tassel66014773tassel_
tassels74510853tassels
tassie66017023tassi_e
tassies74918933tassies
tattily10409993tattily
tawnily1335443tawnily
testily102910803testily
tipsily1236043tipsily
trashily1437323trashily
varsity1356673varsity
vassal979243vassal_
vassals1057953vassals
vastity1336203vastity
vastly12508723va_stly
wackily1936053wackily
warily122915093wa_rily
wassail1056133wassail_
wassails1145953wassails
wavily15219483wa_vily
waxily19218413wa_xily
wispily1535653wispily
yeastily1444573yeastily
zanily18310183za_nily
zestily19167563zestily

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.1431249587.4
2DLD Change Limit1340272726.89019452.4
3Display Results2722720.1102472.7
 (SQL Overall)1786912727.14325016.2
 
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.