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

106 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
glossal844705(None) 
glossa7529161glossa_
glossae8477281glossae
glossas8438191glossas
colossal1045552colossal
dossal75510302_dossal
global937662glo_bal
gloss64319622gloss__
glossary1243372glossary
glossed94410072glossed
glosser83410812glosser
glosses84014122glosses
glossily1235092glossily
glossy10549002gloss_y
glottal835102glottal
gossan747232g_ossan
loessal744392_loessal
abyssal1243763abyssal
alodial899953alodial
arousal748633arousal
blossom11114963blossom
byssal1134993_byssal
clausal936273clausal
cloacal1135163cloacal
clonal8310913clo_nal
costal85419513_costal
crissal937413crissal
dorsal74613943_dorsal
dossals8379293_dossals
dossel74813643_dossel
dossil75110903_dossil
floral94313813flo_ral
floss85118263floss__
flossed11388533flossed
flosser10339693flosser
flosses103411973flosses
flossie10337443flossie
flossily1434523flossily
flossy12517703floss_y
flotsam1244623flotsam
fossa85812633_fossa_
fossae95510373_fossae
fossas94610703_fossas
fossil9379353_fossil
geoidal936713geoidal
glacial1038143glacial
glass65518133glass__
glassed93710433glassed
glasses84414273glasses
glassful12113563glassful
glassie8329493glassie
glassily1235463glassily
glassman1145183glassman
glassy10527753glass_y
glial66715433gl__ial
glissade1043193glissade
gloam86015943glo__am
gloat65427683glo__at
globs85616403globs__
gloms85219783gloms__
glops85619553glops__
gloria71910543gloria_
glorias81610323glorias
glossarial1152263glossarial
glossator1042573glossator
glosseme1144023glosseme
glossers9319053glossers
glossier9358203glossier
glossies93311253glossies
glossina9275543glossina
glossinas10214143glossinas
glossing10278883glossing
glost65422933glo_s_t
glosts74513813glo_sts
glows95518033glows__
gluteal854243gluteal
goal55829303g_o__al
gooral7310463g_ooral
goral65125753g_o_ral
gospel936533g_ospel
gossans836783g_ossans
gossip946433g_ossip
gross65421693gross__
grossed93812253grossed
grosser84313143grosser
grosses84517683grosses
grossly1175983grossly
isoglossal1151123isoglossal
local74820273_lo_cal
loessial843783_loessial
loral55927823_lo_ral
loreal63814313_loreal
losel54419423_lo_sel
loss45337963_loss__
losses65925233_losses
lossy85214643_loss_y
loyal84513483_lo_yal
lyssa835713_lyssa_
lyssas935443_lyssas
missal84314903_missal
ossa43714163__ossa_
postal84317533_postal
sponsal946343sponsal
spousal965533spousal
tussal6288323_tussal
vassal979243_vassal

Search took 7 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.406440125.6
2DLD Change Limit1340271065.76623244.4
3Display Results1061060.0303533.3
 (SQL Overall)1786911066.20228811.8
 
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.