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

227 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
glees6502759(None) 
flees85828751flees
gees55647881g_ees
gelees74116261gelees
ghees95215551ghees
glebes95512241glebes
gledes84915131gledes
gleds75417891gleds
glee55239061glee_
gleed75320571gleed
gleeds84711621gleeds
gleek105315101gleek
gleeks11489671gleeks
gleet65532341gleet
gleets75315051gleets
glens66519851glens
gleys96514851gleys
glues65125681glues
grees65132471grees
lees45455881_lees
aglee65728492aglee_
aglets73915682aglets
agrees74915322agrees
akees96119242akees
alecs76620732alecs
alee46652322alee_
alefs87319662alefs
ales47067102al_es
allees64521482allees
almes75126542almes
aloes54933672aloes
bees65453382_bees
blebs96416152blebs
bleed85019802bleed
bleeds95211592bleeds
bleep95013452bleep
bleeps10499102bleeps
bless75917812bless
blets75324942blets
blues75127042blues
brees75632552brees
cees65941592_cees
cleek115514912cleek
cleeks125010542cleeks
clefs106616242clefs
clepes104214622clepes
clews105516332clews
clues74623032clues
dees56356632_dees
deles65139252deles
drees65628522drees
elves85118742elves
epees75219832epees
fees76450602_fees
fleas86423662fleas
flee76238792flee_
fleer86020772fleer
fleers96015792fleers
fleet85932332fleet
fleets96915062fleets
flews115316442flews
flexes164512952flexes
fleys117015602fleys
flies85630712flies
floes85528142floes
flues84626922flues
frees86131392frees
gaes56348032g_aes
gages74529972gages
galeas74618502galeas
galeres83514322galeres
gales65442482gales
games86238552games
gapes86030822gapes
gases65633992gases
gates65939502gates
gazes155425912gazes
geds66730812g_eds
gee45359202g_ee_
geed65435502g_eed
geek95327022g_eek
geeks104915842geeks
geese64316002g_eese
geest64829612g_eest
geez146424862g_eez
gelds75118342gelds
gelee63626982gelee
gels56836102g_els
gelts65924612gelts
gems75329112g_ems
genes65133092genes
gens55740072g_ens
gets55442482g_ets
ghee85726112ghee_
gibes84422522gibes
gies55641422g_ies
gites65630182gites
gives95324872gives
glaces94218022glaces
glades84820342glades
glads75620612glads
glams85822932glams
glans65125832glans
glares75518862glares
glass65518132glass
glazes165315642glazes
gleam86916732gleam
gleams94812252gleams
glean65818202glean
gleans75014742gleans
gleba83910242gleba
glebe85016442glebe
gled65631142gl_ed
glede75517832glede
gleety10479192gleety
gleg66219802gl_eg
glen56027202gl_en
gley85724652gl_ey
gleyed11478152gleyed
glias64618492glias
glides84518862glides
glimes94717522glimes
glims87417672glims
globes94314542globes
globs85616402globs
gloms85219782gloms
glops85619552glops
gloss64319622gloss
gloves104115182gloves
glows95518032glows
glozes164313352glozes
glue55628492glue_
glued75118362glued
gluer65116772gluer
gluers75011152gluers
gluey95715262gluey
glugs75214282glugs
glumes94516812glumes
glums84621422glums
glutes74517672glutes
gluts66120132gluts
goers65520252goers
goes55644092g_oes
golems939322golems
gores65740372gores
goxes135018262goxes
grebes93813612grebes
gree56641562gree_
greed75125692greed
greeds84314282greeds
greek105915942greek
green65522142green
greens75716872greens
greet65835322greet
greets75117422greets
greys96614852greys
grues65721962grues
gudes74520812gudes
guess64213362guess
gules64831042gules
gybes115012722gybes
gyres94820322gyres
gyves125711552gyves
ileus54616892ileus
ilexes134510252ilexes
jees115938542_jees
knees95114872knees
leas45954182_leas
lee36068142_lee_
leek85331732_leek
leeks95318892_leeks
leer46239352_leer
leers54828982_leers
leet45957902_leet
leets54927122_leets
leges64427282_leges
legs56133692_legs
leis45739602_leis
leks85427602_leks
lenes54738522_lenes
lens46146492_lens
les35663072_l_es
leses54930812_leses
less45635102_less
lets47147942_lets
lexes127225262_lexes
leys76430182_leys
lies46454192_lies
lues45943552_lues
lyes75530832_lyes
melees83618082melees
ogees65119142ogees
oglers74313182oglers
ogles65223182ogl_es
oleos55419682oleos
oles46453472ol_es
pees65257372_pees
peles75738082peles
pleas75627032pleas
plebes104313622plebes
plebs95814582plebs
plews105415352plews
plexes155313532plexes
plies74526512plies
prees75937172prees
rees45364192_rees
sees45361052_sees
skees95023122skees
sleds64418852sleds
sleek94619042sleek
sleeks104512462sleeks
sleep74920182sleep
sleeps83913322sleeps
sleet55639132sleet
sleets64318872sleets
slews86220352slews
sloes54728872sloes
slues54527172slues
tees45353582_tees
teles54536002teles
trees55835762trees
tyees86019452tyees
uglies7412322uglies
vees75439432_vees
wees76249122_wees
ylems1039262ylems
zees136331892_zees

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.0931921408.6
2DLD Change Limit538002271.59333772.8
3Display Results2272270.0633603.2
 (SQL Overall)1786912271.749102167.5
 
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.