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

115 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
glossae847728(None) 
glossa7529161glossa_
glossal8447051glossal
glossas8438191glossas
flossie10337442flossie
fossae95510372_fossae
glassie8329492glassie
glissade1043192glissade
gloss64319622gloss__
glossary1243372glossary
glossed94410072glossed
glosseme1144022glosseme
glosser83410812glosser
glosses84014122glosses
glossier9358202glossier
glossies93311252glossies
glossy10549002gloss_y
gossan747232g_ossan
blossom11114963blossom
blouse84714723blous_e
cloacae1145233cloacae
close76425223clo_s_e
closure9278483closure
colossal1045563colossal
costae85319683_costae
crosse85216313cross_e
dossal75510303_dossal
floosie10378933floosie
florae94713883flo_rae
floss85118263floss__
flossed11388533flossed
flosser10339693flosser
flosses103411973flosses
flossier11326973flossier
flossies112810123flossies
flossy12517703floss_y
flotsam1244623flotsam
fossa85812633_fossa_
fossas94610703_fossas
fossate10388603_fossate
fosse86119463_foss_e
galoshe1135413galo_she
glass65518133glass__
glassed93710433glassed
glasses84414273glasses
glassier9289083glassier
glassies94012273glassies
glassine9329313glassine
glassman1145183glassman
glassmen1145393glassmen
glassware1343223glassware
glassy10527753glass_y
glebae9407613gl_ebae
glissaded1242293glissaded
glissader1142403glissader
glissades1143313glissades
gloam86015943glo__am
gloat65427683glo__at
global937663glo_bal
globate1057823globate
globe84917013glo__be
globose1035543globose
globs85616403globs__
globule1034383globule
gloms85219783gloms__
glops85619553glops__
gloria71910553gloria_
glorias81610323glorias
glossaries1144513glossaries
glossator1042573glossator
glossemes1243783glossemes
glossers9319053glossers
glossiest10277943glossiest
glossily1235093glossily
glossina9275543glossina
glossinas10214143glossinas
glossing10278883glossing
glost65422933glo_s_t
glosts74513813glo_sts
glottal835103glottal
glove94516293glo__ve
glows95518033glows__
gloze154815983glo__ze
goloshe1134733goloshe
goose65925903g_oos_e
gorse65926813g_ors_e
gossamer1143633g_ossamer
gossans836783g_ossans
gossip946433g_ossip
gross65421693gross__
grossed93812263grossed
grosser84313143grosser
grosses84517683grosses
grossly1175983grossly
grosze16457733gro_sze
grouse74315023grous_e
gussie72910153g_ussie
lassie64917743_lassie
lessee64116363_lessee
loessal744393_loessal
loose56627683_loos_e
lose45144583_lo_s_e
loss45337963_loss__
losses65925233_losses
lossy85214643_loss_y
louse56131013_lous_e
lowse87219903_lows_e
lyssa835713_lyssa_
lyssas935443_lyssas
ossa43714163__ossa_
plisse8368403pliss_e
plosive1236673plosive
plussage1143223plussage
posse74722273_poss_e
prossie91812963prossie

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.390458182.1
2DLD Change Limit1340271155.61023890.7
3Display Results1151150.0462500.0
 (SQL Overall)1786911156.04629555.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.