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

283 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
glossa752916(None) 
gloss64319621gloss_
glossae8477281glossae
glossal8447051glossal
glossas8438191glossas
glossy10549001glossy
floss85118262floss_
flossy12517702flossy
fossa85812632_fossa
glass65518132glass_
glassy10527752glassy
globs85616402globs_
gloms85219782gloms_
glops85619552glops_
gloria71910542gloria
glossary1243372glossary
glossed94410072glossed
glosser83410812glosser
glosses84014122glosses
glossina9275542glossina
glost65422932glo_st
glosts74513812glosts
glows95518032glows_
gossan747232g_ossan
gross65421692gross_
loss45337962_loss_
lossy85214642_lossy
lyssa835712_lyssa
ossa43714162__ossa
agnosia837643agnosia
alaska1036713alaska
alodia71112453alodia
aloes54933673aloes_
aloha8513613alo_ha
alohas9411703alohas
bless75917813bless_
bliss75616913bliss_
blobs95620033blobs_
blocs95219653blocs_
blogs85319233blogs_
blossom11114963blossom
blots75626173blots_
blouse84714723blouse
blousy11459123blousy
blows105423833blows_
blowsy14579453blowsy
boss65938343_boss_
bossy105515973_bossy
bugloss1035893bugloss_
celosia939463celosia
class75525483class_
classy11379043classy
cloaca1037263cloaca
clods85320863clods_
clogs85519553clogs_
clons75228133clons_
clops95924853clops_
close76425223clo_se
closed95317963closed
closer84918203closer
closes85425593closes
closest94312533closest
closet85226603closet
clots75627643clots_
cloys104916943cloys_
colossal1045553colossal
colossi935673colossi
coss66143493_coss_
costa75523733_costa
crissa837623crissa
cross75124503cross_
crosse85216303crosse
diglossia1152283diglossia
dorsa64617283_dorsa
doss56235043_doss_
dossal75510303_dossal
dross65418093dross_
drossy10528473drossy
elodea738673elodea
flocs105519233flocs_
floes85528143floes_
flogs95919963flogs_
floosy12368153floosy
flops105920143flops_
flora85317103flo_ra
floras94715693floras
flossed11388533flossed
flosser10339693flosser
flosses103411973flosses
flossie10337443flossie
flota85315643flo_ta
flotas94013003flotas
flotsam1244613flotsam
flows115822363flows_
foss76431643_foss_
fossae95510373_fossae
fossas94610703_fossas
fosse86119463_fosse
galops94712613galops_
galosh1038553galo_sh
galoshe1135393galoshe
gaols66717573gaols_
gassy95514023g_assy
gauss65613453gauss_
geisha1035193geisha
gesso649603g_esso
ghost96318763gho_st
ghosts10489273ghosts
ghosty13467213ghosty
glads75620613glads_
glams85822933glams_
glans65125833glans_
glassed93710433glassed
glasses84414273glasses
glassie8329493glassie
glassman1145183glassman
gleba83910243gl_eba
gleds75417893gleds_
glees65027593glees_
glens66519853glens_
gleys96514853gleys_
glia56423153gl__ia
glias64618493glias_
glims87417673glims_
glioma935953glioma
gliomas1035333gliomas
glissade1043193glissade
gloam86015943glo_am
gloams95210663gloams
gloat65427683glo_at
gloats74515423gloats
glob76623393glo__b
global937663global
globby1434683globby
globe84917013glo_be
globed104811763globed
globes94314543globes
globin9309723globin
globose1035543globose
glogg837353glo_gg
gloggs935033gloggs
glom75424383glo__m
glomera1035943glomera
glomus9468093glomus
gloom87116523glo_om
glooms96211683glooms
gloomy12528763gloomy
glop76724633glo__p
gloppy1454723gloppy
glorias81610313glorias
glory96413293glo_ry
glossator1042573glossator
glosseme1144023glosseme
glossers9319053glossers
glossier9358203glossier
glossies93311253glossies
glossily1235093glossily
glossinas10214143glossinas
glossing10278883glossing
glottal835103glottal
glout65925813glo_ut
glouts74414713glouts
glove94516293glo_ve
gloved114811873gloved
glover104513533glover
gloves104115183gloves
glow85222523glo__w
glowed114913833glowed
glower105114933glower
gloze154815983glo_ze
glozed173711223glozed
glozes164313353glozes
glues65125683glues_
glugs75214283glugs_
glums84621423glums_
gluons738503gluons_
gluts66120133gluts_
gnoses76515163gnoses
gnosis75711213gnosis
goa47343803g_o__a
goas55239943g_oas_
gobs76935573g_obs_
gods65438043g_ods_
goes55644093g_oes_
golds75421313golds_
golfs95616103golfs_
golosh1036463golosh
goloshe1134723goloshe
gonia64117533g_onia
goods75124483goods_
goofs94821003goofs_
gooks105422883gooks_
goons65326773goons_
goops86620963goops_
goos57644913g_oos_
goose65925903g_oose
goosed86817033goosed
gooses75723053gooses
goosey105913513goosey
goosy96018883g_oosy
gorse65926813g_orse
gorsy95915783g_orsy
gos47155133g_o_s_
gosh86123423g_o_sh
gossans836783g_ossans
gossip946433g_ossip
goys86328413g_oys_
grass66125203grass_
grassy10619093grassy
grogs76319413grogs_
groks105716123groks_
grossed93812253grossed
grosser84313143grosser
grosses84517683grosses
grossly1175983grossly
grosz154814093gro_sz
grosze16457733grosze
groszy19395703groszy
grots65025853grots_
grouse74315023grouse
grows95523923grows_
guess64213363guess_
gussy95314323g_ussy
gyoza1836113gyo_za
gyozas1933603gyozas
hosta85917833_hosta
igloos738033igloos_
joss115925593_joss_
koss85224813_koss_
lass47444543_lass_
lassi56316853_lassi
lasso55015683_lasso
less45635103_less_
lobs66441083_lobs_
loca65527683_lo_ca
loess55714703_loess
loessal744393_loessal
logia68116603_logia
logs57343113_logs_
loofa85912813_loofa
loos49051123_loos_
loose56627683_loose
lops66043353_lops_
lose45144583_lo_se
losel54419423_losel
loser54728673_loser
loses56742013_loses
losses65925233_losses
lost47951493_lo_st
lota47233503_lo_ta
lotas55926303_lotas
lots47652093_lots_
louma76213633_louma
louse56131013_louse
lousy84617083_lousy
lows75843013_lows_
lowse87219903_lowse
lyssas935443_lyssas
massa75518923_massa
moss67641033_moss_
mosso74715183_mosso
mossy105217063_mossy
ossia53710403__ossia
plasma103810913plasma
plisse8368403plisse
plods85719293plods_
plops95920333plops_
plots75025673plots_
plows105419903plows_
ploys105816593ploys_
posse74722273_posse
pross76529403pross_
regloss8218023regloss_
slobs74419873slobs_
sloes54728873sloes_
slogs64521843slogs_
slops75026013slops_
slosh84514483slo_sh
sloshy12366623sloshy
slots54830523slots_
slows85323463slows_
stoss54316343stoss_
toss45637973_toss_

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162835.72019705.6
3Display Results2832830.0933043.0
 (SQL Overall)1786912835.95330017.0
 
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.