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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

113 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
gleet6553234(None) 
fleet85932331fleet
glee55239061glee_
gleed75320571gleed
gleek105315101gleek
glees65027591glees
gleets75315051gleets
gleety10479191gleety
greet65835321greet
leet45957901_leet
sleet55639131sleet
aglee65728492aglee_
aglet65534142agl_et
alee46652322alee_
alert54740652alert
beet66457542_beet
bleat75737002bleat
bleed85019802bleed
bleep95013452bleep
blent76230952blent
blest76431722blest
blet66247672bl_et
bluet75631192bluet
cleat76335062cleat
cleek115514912cleek
cleft106222852cleft
clept95725772clept
deet57356582_deet
elect74327032elect
feet75352212_feet
flee76238792flee_
fleer86020772fleer
flees85828752flees
fleets96915062fleets
gallet73630852gallet
gee45359202g_ee_
geed65435502g_eed
geek95327022g_eek
gees55647882g_ees
geest64829612geest
geez146424862g_eez
gelee63626982gelee
gelees74116262gelees
gelt56448012g_elt
genet66038682genet
gent56954392g_ent
gest56149132g_est
get47467462g__et
ghee85726112ghee_
ghees95215552ghees
gleam86916732gleam
glean65818202glean
gleba83910242gleba
glebe85016442glebe
glebes95512242glebes
gled65631142gl_ed
glede75517832glede
gledes84915132gledes
gleds75417892gleds
gleeds84711622gleeds
gleeks11489672gleeks
gleeted9379322gleeted
gleg66219802gl_eg
glen56027202gl_en
glens66519852glens
gley85724652gl_ey
gleyed11478152gleyed
gleys96514852gleys
glint66830182glint
gloat65427682gloat
glost65422932glost
glout65925812glout
glue55628492glue_
glued75118362glued
gluer65116772gluer
glues65125682glues
gluey95715262gluey
glut56331292gl_ut
glute66020902glute
godet7530042godet
great66034242great
gree56641562gree_
greed75125692greed
greek105915942greek
green65522142green
grees65132472grees
greets75117422greets
guest65225922guest
gullet74924832gullet
keet85347332_keet
lee36068142_lee_
leek85331732_leek
leer46239352_leer
lees45455882_lees
leets54927122_leets
left76340482_left
lent46360532_lent
lept66440882_lept
lest46956322_lest
let36481472_l_et
meet65350552_meet
pleat74734472pleat
relet54749822relet
sheet84836962sheet
skeet95429182skeet
sleek94619042sleek
sleep74920182sleep
sleets64318872sleets
sleety94112652sleety
slept75728102slept
sweet85330522sweet
tweet84823982tweet
weet75254152_weet

Search took 2 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.1431249587.4
2DLD Change Limit538001131.60633499.4
3Display Results1131130.0333424.2
 (SQL Overall)1786911131.782100275.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.