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

212 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
glossier935820(None) 
flossier11326971flossier
glassier9289081glassier
glosser83410811gloss_er
glossies93311251glossies
blousier1055662blousier
blowsier1335062blowsier
bossier93712422_bossier
classier10359082classier
dossier83711692_dossier
drossier956312drossier
flosser10339692floss_er
flossie10337442flossie_
flossies112810122flossies
gassier83812572g_assier
ghostier1235382ghostier
glassie8329492glassie_
glassies94012272glassies
globbier1334242globbier
gloomier1135092gloomier
gloppier1354672gloppier
glossae8477282glossae_
glossed94410072gloss_ed
glossers9319052gloss_ers
glosses84014122gloss_es
glossiest10277942glossiest
glossily1235092glossily
glossina9275542glossina
glossing10278882glossing
goosier83512562g_oosier
gorsier83811072g_orsier
gossiper1164202g_ossiper
grassier9349282grassier
grosser84313142gross_er
lousier72411622_lousier
mossier94413812_mossier
sloshier1135282sloshier
blastier10249493blastier
blesser9329293bless_er
blockier1666133blockier
bloodier1136823bloodier
bloomier1275783bloomier
blottier10336413blottier
blowier1248943blo_wier
blowzier2233413blowzier
bluesier1034943bluesier
boskier13309173_boskier
bossies94116833_bossies
brassier103310533brassier
choosier1337173choosier
classer93614613class_er
cloddier1234063cloddier
cloggier1244253cloggier
cloister1037093cloister
closer84918203clo_s_er
clothier1335363clothier
cloudier1135053cloudier
clumsier1234733clumsier
cosier84423753_co_sier
crosier94116573cro_sier
crosser95015463cross_er
dosser74417973_doss_er
dossiers9318043_dossiers
dressier956863dressier
drowsier1284903drowsier
flashier1437103flashier
fleshier1435603fleshier
flimsier1344133flimsier
floatier1136983floatier
flockier1745343flockier
floosie10378933floosie_
floosies113210233floosies
floppier1554633floppier
flossed11388533floss_ed
flossers11307863floss_ers
flosses103411973floss_es
flossiest12296803flossiest
flossily1434523flossily
flossing12247903flossing
folksier1533533folksier
frostier1148163frostier
frowsier1444893frowsier
fussier103610673_fussier
gasolier935833gasolier
gasser75017773g_ass_er
ghostlier1343343ghostlier
glacier103911293gl_acier
gladier93810993gl_adier
gladlier1034343gladlier
glairier944833glairier
glarier84112203gl_arier
glassed93710433glass_ed
glasses84414273glass_es
glassiest10279243glassiest
glassily1235463glassily
glassine9329313glassine
glassines10278043glassines
glassing10329973glassing
glassmen1145393glassmen
glazier17409353gl_azier
gleamier1144913gleamier
gleetier934913gleetier
glintier945703glintier
glissader1142403glissader
glister84013343gl_ister
glitzier1833593glitzier
gloater83711013glo_ater
gloried9169513glo_ried
glories81915913glo_ries
glorifier1344233glorifier
gloss64319623gloss___
glossa7529163gloss__a
glossal8447053gloss_al
glossaries1144513glossaries
glossary1243373glossary
glossas8438193gloss_as
glossator1042573glossator
glosseme1144023glosseme
glossemes1243783glossemes
glossinas10214143glossinas
glossiness11284983glossiness
glossitic12163433glossitic
glossitis10143593glossitis
glossy10549003gloss__y
glover104513533glo__ver
glower105114933glo__wer
gluier7310263gl__uier
glumpier1334873glumpier
godlier938893g_odlier
goodlier1035793goodlier
goofier11339313g_oofier
gooier73516213g_o_oier
goonier83612843g_oonier
goopier103910573g_oopier
gorier73719373g_o_rier
gossamer1143633g_ossamer
gossip946433g_ossi_p
gossiped1263513g_ossiped
gossipers1263543g_ossipers
gossipper1472593g_ossipper
gossipry1441903g_ossipry
gossips1035903g_ossips
gossipy1343953g_ossipy
goutier82612353g_outier
greasier9298083greasier
grislier935793grislier
grodier939673gro_dier
groggier1134343groggier
groovier1233793groovier
grossed93812253gross_ed
grossers94410973gross_ers
grosses84517683gross_es
grossing103111063grossing
grottier9316673grottier
grouser84513693grous_er
groutier9297173groutier
growlier1234883growlier
guesser8166543guess_er
gushier113110073g_ushier
gussie72910153g_ussie_
gussied9267193g_ussied
gussies82813303g_ussies
gustier83813863g_ustier
gutsier8389823g_utsier
hissier103410503_hissier
horsier103013243_horsier
hosier94219613_ho_sier
lassie64917743_lassie_
lassies74420103_lassies
lassoer7379383_lassoer
lesser63514853_less_er
loamier9349163_loamier
lobster9288853_lobster
loftier1037763_loftier
loggier93811143_loggier
logier75015733_lo_gier
loonier73312683_loonier
loopier93711193_loopier
looser65219943_loos_er
loppier11369723_loppier
loser54728673_lo_s_er
losses65925233_loss_es
lowlier10338903_lowlier
lustier73813503_lustier
massier93615223_massier
messier93412923_messier
mosser84618273_moss_er
mousier93712463_mousier
mussier93314363_mussier
noisier759453_noisier
nosier63716323_no_sier
osier53518013__o_sier
plashier1337613plashier
plottier10327263plottier
plushier1375193plushier
prissier10157873prissier
prosier93817483pro_sier
prossie91812953prossie_
prossies101515223prossies
pussier93711993_pussier
rosier64221263_ro_sier
sassier73413233_sassier
sissier73711363_sissier
slimsier1085213slimsier
slobbier1254633slobbier
sloppier1255703sloppier
slushier1135983slushier
sonsier7711743_sonsier
tosser64215663_toss_er
tressier847963tressier
woodsier1245473woodsier
wussier10408083_wussier

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622126.25023385.9
3Display Results2122120.0762789.5
 (SQL Overall)1786912126.73226543.5
 
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.