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

163 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
glossas843819(None) 
glossa7529161glossa_
glossae8477281glossae
glossal8447051glossal
glosses84014121glosses
flosses103411972flosses
fossas94610702_fossas
glasses84414272glasses
glorias81610322glorias
gloss64319622glo_s_s
glossary1243372glossary
glossed94410072glossed
glosser83410812glosser
glossers9319052glossers
glossies93311252glossies
glossinas10214142glossinas
glossy10549002gloss_y
glosts74513812glo_sts
gossan747232g_ossan
gossans836782g_ossans
grosses84517682grosses
losses65925232_losses
lyssas935442_lyssas
agnosias947243agnosias
alaskas1136683alaskas
alohas9411703alo_has
blesses93812393blesses
blisses94911513blisses
blossom11114963blossom
blossoms12134553blossoms
blouses94014463blouses
bosses85925403_bosses
buglosses1243543buglosses
celosias1048903celosias
classes94717943classes
classis93712723classis
cloacas1136233cloacas
closers94415323closers
closes85425593clo_ses
closets94611603closets
colossal1045553colossal
colossus1045183colossus
crosses94220793crosses
diglossias1252083diglossias
dossal75510303_dossal
dossals8379293_dossals
dosses76126273_dosses
drosses84513823drosses
elodeas836963elodeas
floras94715693flo_ras
floss85118263flo_s_s
flossed11388533flossed
flosser10339693flosser
flossers11307863flossers
flossie10337443flossie
flossies112810123flossies
flossy12517703floss_y
flotas94013003flo_tas
flotsam1244623flotsam
flotsams1343383flotsams
fossa85812633_fossa_
fossae95510373_fossae
fosses96022083_fosses
galoshes1236893galoshes
gasses75724783g_asses
gausses8308693gausses
geishas1135073geishas
ghosts10489273gho_sts
glass65518133gl_as_s
glassed93710433glassed
glassie8329493glassie
glassies94012273glassies
glassman1145183glassman
glassy10527753glass_y
glias64618493gl__ias
gliomas1035333gliomas
glissade1043193glissade
glissades1143313glissades
gloam86015943glo__am
gloams95210663glo_ams
gloat65427683glo__at
gloats74515423glo_ats
global937663glo_bal
globes94314543glo_bes
globins10278953globins
globous1036503globous
globs85616403glo__bs
gloggs935033glo_ggs
gloms85219783glo__ms
glomus9468093glo_mus
glooms96211683glo_oms
glops85619553glo__ps
gloria71910543gloria_
glories81915913glories
glossaries1144513glossaries
glossarist1153603glossarist
glossator1042573glossator
glossators1152553glossators
glosseme1144023glosseme
glossemes1243783glossemes
glossier9358203glossier
glossiest10277943glossiest
glossily1235093glossily
glossina9275543glossina
glossing10278883glossing
glossitis10143593glossitis
glost65422933glo_s_t
glottal835103glottal
glottis837173glottis
glouts74414713glo_uts
glovers114310883glovers
gloves104115183glo_ves
glowers113412093glowers
glows95518033glo__ws
glozes164313353glo_zes
gnoses76515163gno_ses
gnosis75711213gno_sis
goas55239943g_o__as
goloshes1236253goloshes
gooses75723053g_ooses
gorses74723293g_orses
gossip946433g_ossip
gossips1035903g_ossips
grasses84117343grasses
gross65421693gro_s_s
grossed93812253grossed
grosser84313143grosser
grossers94410973grossers
grossest93810093grossest
grossly1175983grossly
grouses84616543grouses
guesses8169373guesses
gyozas1933613gyo_zas
hostas94515823_hostas
josses135117683_josses
lasses64827593_lasses
lassis65216703_lassis
lassos64913813_lassos
loess55714703_loes_s
loessal744393_loessal
loesses7310033_loesses
loofas9429833_loofas
looses67328243_looses
losels64714583_losels
losers65123583_losers
loses56742013_lo_ses
loss45337963_lo_s_s
lossy85214643_loss_y
lotas55926303_lo_tas
loumas84812333_loumas
louses66230283_louses
lyssa835713_lyssa_
massas85116463_massas
mosses85527683_mosses
ossa43714163__ossa_
plasmas113010753plasmas
plisses94411773plisses
plusses93510693plusses
posses85128803_posses
prosses94019513prosses
reglosses1045343reglosses
sloshes103811803sloshes
tosses65225393_tosses

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.403443402.0
2DLD Change Limit1340271636.56320421.6
3Display Results1631630.0632587.3
 (SQL Overall)1786911637.02925422.0
 
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.