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 “gloze” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
gloze15481598(None) 
cloze165517541cloze
glaze155418161glaze
globe84917011globe
glove94516291glove
glozed173711221glozed
glozes164313351glozes
adoze155713832adoze
aloe45540192alo_e
alone55732962alone
blaze165520832blaze
bloke114316632bloke
booze164718912booze
clone75728162clone
close76425222close
clove105619442clove
clozes174915562clozes
croze164719452croze
doze145829082_doze
elope75219342elope
floe76129772flo_e
froze174515652froze
galore73514872galore
gauze155712972gauze
gaze145032412g_aze
geode7412592geode
glace87420162glace
glade75121962glade
glare65222962glare
glazed174711772glazed
glazer164212262glazer
glazes165315642glazes
glazy187410982glazy
glebe85016442glebe
glede75517832glede
glee55239062gl_ee
glide74521592glide
glime85620192glime
gloam86015942gloam
gloat65427682gloat
glob76623392glo_b
globed104811762globed
globes94314542globes
globs85616402globs
glogg837352glogg
glom75424382glo_m
gloms85219782gloms
gloom87116522gloom
glop76724632glo_p
glops85619552glops
glory96413292glory
gloss64319622gloss
glost65422932glost
glout65925812glout
gloved114811872gloved
glover104513532glover
gloves104115182gloves
glow85222522glo_w
glowed114913832glowed
glower105114932glower
glows95518032glows
glue55628492gl_ue
glume85120462glume
glute66020902glute
gnome84213952gnome
gone55639042g_one
goose65925902goose
gore55744962g_ore
graze155820052graze
grope84821612grope
grosze16457732grosze
grove95219332grove
gyoza1836112gyoza
laze136235052_laze
lobe65535362_lobe
lode56240112_lode
loge56837192_loge
lone45849132_lone
lope65941922_lope
lore45850352_lore
lose45144582_lose
love75234762_love
lowe75435312_lowe
ooze136420602_ooze
sloe45534952slo_e
slope75823562slope
zlote143912942zlote

Search took 5 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 Filter178691538000.936190909.2
2DLD Change Limit53800873.68614595.8
3Display Results87870.0461891.3
 (SQL Overall)178691874.66838280.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.