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

108 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
glean6581820(None) 
clean75420411clean
gleam86916731gleam
gleans75014741gleans
glen56027201gle_n
lean46345241_lean
agleam9158622agleam
alan46844082al_an
bean66443862_bean
bleak115915382bleak
blear75918682blear
bleat75737002bleat
clan65633922cl_an
cleans85817052cleans
clear76219052clear
cleat76335062cleat
dean56039482_dean
elan46734242el_an
flan76134182fl_an
flea75628492flea_
fleam106017282fleam
fleas86423662fleas
gaen57329602gae_n
galea64722932galea_
galeae74717452galeae
galeas74618512galeas
galena74911092galena
gan48060132g__an
gear55934972g_ear
gelant72821672gelant
gen45950512g_e_n
gien56330022gie_n
glad65624012gl_ad
glam76529342gl_am
gland75217712gl_and
glans65125832gl_ans
gleams94812252gleams
gleamy12398112gleamy
gleaned9349422gleaned
gleaner8379772gleaner
gleba83910242gleba
glebae9407612glebae
glebe85016442glebe
gled65631142gle_d
glede75517832glede
gleds75417892gleds
glee55239062gle_e
gleed75320572gleed
gleek105315102gleek
gleeman1035362gleeman
glees65027592glees
gleet65532342gleet
gleg66219802gle_g
glens66519852glens
gley85724652gle_y
gleys96514852gleys
glia56423152glia_
glial66715432glial
glias64618492glias
gloam86015942gloam
gloat65427682gloat
glucan936182glucan
gluon6311222gluon
glycan1234902glycan
goban84414072goban
gowan95415742gowan
gran56335012g_ran
great66034242great
green65522142green
groan65618422groan
guan55325582g_uan
ilea45931462ilea_
ileac75814172ileac
ileal56118082ileal
jean116629282_jean
lea37660182_lea_
lead56038852_lead
leaf76441032_leaf
leak86233712_leak
leal46043272_leal
leans55536252_leans
leant56737782_leant
leap66032682_leap
lear47045952_lear
learn55322662_learn
leas45954182_leas
leman75622602_leman
loan47436452_loan
mean65538092_mean
ocean71212962ocean
olea46532722olea_
olein5316002olein
paean77222722paean
pean66147172_pean
plan65833942pl_an
plea66830602plea_
plead85818462plead
pleas75627032pleas
pleat74734472pleat
plena75816392plena
pleon74216382pleon
quean143612842quean
skean94415622skean
spean74620512spean
ulan46527392ul_an
ulpan7310122ulpan
wean75734352_wean
yean75834582_yean

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.310576422.6
2DLD Change Limit538001081.54634799.5
3Display Results1081080.0333272.7
 (SQL Overall)1786911081.88994595.6
 
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.