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

133 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
learn5532266(None) 
earn46737551_earn
lean46345241lea_n
lear47045951lear_
learns65513741learns
learnt64019251learnt
lears55938731lears
leary85927381leary
yearn86316431yearn
barn66444642_barn
bean66443862bea_n
bear66844642bear_
beard86024962beard
bears75739042bears
blear75918682blear_
blears85116452blears
bleary115112552bleary
carn66245432_carn
cedarn9408442cedarn
clean75420412clea_n
clear76219052clear_
clears84116562clears
darn56434622_darn
dean56039482dea_n
dear55343602dear_
dears65736882dears
deary95826842deary
ear36867882_ear_
earl45838142_earl
earns55927562_earns
ears46356592_ears
elain55324702elain
elan46734242ela_n
ern35738362_e_rn
fear75337792fear_
fears84829392fears
fern76129322fe_rn
gear55934972gear_
gears64628692gears
glean65818202glea_n
hear76143882hear_
heard95222752heard
hears86737372hears
heart85440742heart
hern76134892he_rn
jean116629282jea_n
karn86129432_karn
kern85326222ke_rn
laari54415712laari
lain46146282l_ain
lar37967532l_ar_
lard56742002l_ard
lari45839152l_ari
lark85733862l_ark
lars46956572l_ars
lawn75925632l_awn
lea37660182lea__
leach105422522leach
lead56038852lea_d
leaden74515222leaden
leads66028492leads
leady95618602leady
leaf76441032lea_f
leafs85721182leafs
leafy116316212leafy
leak86233712lea_k
leaks95923912leaks
leaky125217722leaky
leal46043272lea_l
leans55536252leans
leant56737782leant
leap66032682lea_p
leaps75522932leaps
leapt75027472leapt
learned8329302learned
learner7319382learner
leas45954182lea_s
lease55230262lease
leash85519212leash
least56134882least
leave84723722leave
leaven95013072leaven
leavy115715772leavy
leben7314852leben
leer46239352leer_
leers54828982leers
leery85919132leery
lehr75514942lehr_
lehrs86111132lehrs
leman75622602leman
lemon75618182lemon
levin84816412levin
liar47229692liar_
liard65418592liard
liars54723162liars
loan47436452loa_n
loran55925092loran
lorn46435252l_orn
lyard95113212lyard
lyart85121882lyart
mean65538092mea_n
near45236502near_
nears55529422nears
pean66147172pea_n
pear69745232pear_
pearl75324462pearl
pears75138612pears
peart76440752peart
rear45644552rear_
rearm75923572rearm
rears54739652rears
reearn6612142reearn
relearn747972relearn
reran57329102reran
sear47353842sear_
sears54744912sears
sharn84823702sharn
tarn46842722_tarn
tear45242882tear_
tears55436462tears
teary85124052teary
tern46134802te_rn
unlearn735952unlearn
warn75239322_warn
wean75734352wea_n
wear75836722wear_
wears86030302wears
weary115620612weary
yarn75230042_yarn
yean75834582yea_n
year76534252year_
yearns9509542yearns
years84527672years

Search took 4 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.626285448.9
2DLD Change Limit538001333.20016812.5
3Display Results1331330.0632111.1
 (SQL Overall)1786911333.88945947.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.