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

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

531 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
learner731938(None) 
earner63617221_earner
leaner64022191lea_ner
learier73415661learier
learned8329301learned
learners8398151learners
yearner10336871yearner
bearer85323912bear_er
blearier1037332blearier
cleaner93712302clea_ner
clearer93710822clear_er
darner74017302_darner
dearer74822802dear_er
earned74818332_earned
earners74016452_earners
fearer94820182fear_er
garner73917002_garner
gleaner8379772glea_ner
hearer94323642hear_er
lanner64920602l_anner
larder73720972l_arder
larger74417512l_arger
larker104519242l_arker
leacher124014842leacher
leader74824652lea_der
leadier83212722leadier
leafier10329832leafier
leaguer835792leaguer
leaker104620072lea_ker
leakier114010992leakier
leaned73422542lea_ned
leaners73718172lea_ners
leaper88118942lea_per
learn55322662learn__
learns65513742learn_s
learnt64019252learn_t
leaser65322672lea_ser
leather103815782leather
leaver94321512lea_ver
leavier10319992leavier
leerier73111502leerier
loaner64416502loa_ner
meaner84617842mea_ner
nearer64618892near_er
pearler9310372pearler
pearter9412742pearter
rearer64928912rear_er
searer65432022sear_er
tearer64822902tear_er
tearier73815612tearier
warner93717222_warner
weaner93816772wea_ner
wearer94319402wear_er
wearier103613282wearier
yarner93313062_yarner
yearned11327372yearned
yearners11346372yearners
adorner8246983adorner
aerier64823153ae_rier
alerter72111513ale_rter
armer76924443__armer
awarder1135893awarder
banner84421503_banner
barber104419323_barber
barer74535803_bar_er
barker124822863_barker
barned95623583_barned
barney115314453_barney
barnier93213673_barnier
barter85525373_barter
beader94623793bea_der
beadier103513913beadier
beaker125520693bea_ker
beakier134012163beakier
beamier113411943beamier
beaned95621473bea_ned
beanery1237563bea_nery
bearded114212133bearded
bearers94619593bear_ers
beater84729393bea_ter
beaver114819253bea_ver
beerier93613023beerier
blarney12174763blarney
bleacher15358883bleacher
bleaker133510533blea_ker
bleared104211253blear_ed
bleater94515303blea_ter
boarder103910323boarder
branner94212373branner
burner83819203_burner
caner75334773_ca_ner
canner84625983_canner
carder94524183_carder
career85822243_career
carer74942333_car_er
carnet84732873_carnet
carney115315703_carney
carper104923633_carper
carter84932273_carter
carver114420143_carver
centner946853centner
charger133914063charger
charier124317903charier
charmer144913663charmer
charnel124010053charnel
charter123918303charter
churner12298343churner
cleaned103512003clea_ned
cleaners103610543clea_ners
cleanser10356313cleanser
cleared103612463clear_ed
clearers10349303clear_ers
clearness1135633clearness
cleaver124110803clea_ver
coarser93211203coarser
corner84625623_corner
damner95213433_damner
darer65230793_dar_er
darker114718693_darker
darned85018483_darned
darnel74312183_darnel
darners83815773_darners
darter75320363_darter
deadener1036743deadener
deader84220473dea_der
deafer104114813dea_fer
dealer74122143dea_ler
deaned84620453dea_ned
deanery1137613dea_nery
dearie73319813dearie_
dearies83526273dearies
dearness939973dearness
debarker15155503debarker
deboner103110483deboner
decreer10269123decreer
decrier102713553decrier
definer114413773definer
dehorner1235523dehorner
deranger1037353deranger
dernier83011943de_rnier
detainer92910793detainer
drainer83012843drainer
drearier9297923drearier
dwarfer1433683dwarfer
eager65526963_ea_ger
eared65139503_ear_ed
earlier72612743_earlier
earn46737553_earn__
earnest7318733_earnest
earns55927563_earn_s
easier64218463_easier
easter65027983_easter
eater54639843_ea_ter
eerier64320023_eerier
elater64724203ela_ter
eloiner7149183eloiner
eraser64216333_eraser
erne46727423_e_rne_
ernes55224813_e_rnes
evener91010623_evener
fainer94717243_fainer
fanner94218183_fanner
farcer115016083_farcer
farer86733143_far_er
farmer115017373_farmer
fawner125910463_fawner
feared106320433fear_ed
fearers104815273fear_ers
feaster10812983feaster
feater95224053fea_ter
feather133613503feather
feigner1135593feigner
fernery1335813fe_rnery
fernier103110823fe_rnier
gainer74117493_gainer
garners83815983_garners
garnet73928413_garnet
garter74420513_garter
geared85317743gear_ed
glarier84112203glarier
gleamer10328513glea_mer
gleamier1144913gleamier
gleaned9349423glea_ned
gleaners9348073glea_ners
grainer83714063grainer
guarder936463guarder
harder105022403_harder
harmer114719553_harmer
harper115018403_harper
header104422543hea_der
headier113212953headier
healer94221803hea_ler
heaper114119523hea_per
hearers104319783hear_ers
hearken14338023hearken
hearkener1644213hearkener
hearse94114273hearse_
hearsed113811403hearsed
hearses104414533hearses
hearted113314023hearted
hearten102411753hearten
heartener1256763heartener
heartier1139093heartier
heater94828303hea_ter
heather133914853heather
heaver124819673hea_ver
heavier13429423heavier
herder104516463he_rder
hoarder11329233hoarder
hoarier104211743hoarier
hoarser10388393hoarser
inaner62213543ina_ner
jeaned143813463jea_ned
jeerer13389933jeer_er
jerker17369043je_rker
keener104012833ke_ener
kerne94718213ke_rne_
kerned114112923ke_rned
kernel104010583ke_rnel
kernes104717523ke_rnes
laager74312783l_aager
lacer75833753l_a_cer
lacier84020093l_acier
lacker125325623l_acker
ladder84617623l_adder
lader65633723l_a_der
ladler74314933l_adler
lager65132863l_a_ger
lagger85919833l_agger
laker95432873l_a_ker
lakier104716273l_akier
lamber104418493l_amber
lamer75233703l_a_mer
lancer84319973l_ancer
lander74028483l_ander
lane45153333l_a_ne_
lanes54946793l_a_nes
lanker104123003l_anker
lanners73618333l_anners
lapper104319953l_apper
lapser84113143l_apser
larcener1036493l_arcener
larded84319093l_arded
larders83516943l_arders
lardier83518343l_ardier
laree56036293l_ar_ee
larees65323113l_arees
lares54852633l_ar_es
large65325463l_arge_
larges74824233l_arges
larine63927043l_arine_
larked114519473l_arked
larkers113014513l_arkers
larkier113711523l_arkier
laser54633323l_a_ser
lasher94824533l_asher
laster64830633l_aster
later54843923l_a_ter
lather95124353l_ather
latter65027893l_atter
lauder73815013l_auder
launder8309143l_aunder
laveer94110423l_aveer
laver85031793l_a_ver
lawyer12386973l_awyer
laxer125420333l_a_xer
layer84626473l_a_yer
lazier154214613l_azier
leached133715043leached
leachers133712813leachers
leaches123319343leaches
leachier1337253leachier
leaded84221543lea_ded
leaden74515223lea_den
leadened1036153leadened
leadens83610983leadens
leaders83819603lea_ders
leadmen10277903leadmen
leafed105713873lea_fed
leaflet10199743leaflet
league758743league_
leagued935463leagued
leaguers935063leaguers
leagues837943leagues
leaked114217703lea_ked
leakers113415423lea_kers
lean46345243lea_n__
leanest7415863lea_nest
leanly93811503lea_nly
leanness837373leanness
leans55536253lea_n_s
leant56737783lea_n_t
leaped94317773lea_ped
leapers93716663lea_pers
lear47045953lea___r
leariest83117843leariest
learnedly1342823learnedly
learning978553learning
lears55938733lear__s
leary85927383lear__y
lease55230263lea_se_
leased74722883lea_sed
leasers74717843lea_sers
leases65428113lea_ses
leashed113211163leashed
leashes103514403leashes
leathern11398913leathern
leathers114215083leathers
leathery14438973leathery
leave84723723lea_ve_
leaved105719023lea_ved
leaven95013073lea_ven
leavened1235553leavened
leavens10409303leavens
leavers103717783lea_vers
leaves94222383lea_ves
lecher113415853le_cher
ledger85914363le_dger
ledgier9458493ledgier
leer46239353le___er
leered73816223leer_ed
lefter93613433le_fter
leger65721503le__ger
leggier9368233leggier
legwarmer1542083legwarmer
leister73212753leister
lender73921273le_nder
lenes54738523le__nes
leone55018823le_one_
leones64417723le_ones
leper74820743le__per
lesser63514853le_sser
letter63722583le_tter
levanter1145303levanter
leveler10399903leveler
lever85125163le__ver
levier94013873le_vier
lewder10479613le_wder
liane54720663lia_ne_
lianes63819323lia_nes
lierne638023lierne_
liernes739623liernes
limner84112873l_imner
liner55938923l__iner
livener10278943livener
loader74316313loa_der
loafer93610943loa_fer
loamier9349163loamier
loaned73816293loa_ned
loaners73913623loa_ners
loather103711003loather
loner55431043l__oner
loriner7511893loriner
lucarne944263lucarne_
lucarnes1045093lucarnes
lurer54625313l_ur_er
lurker103613293l_urker
manner84020513_manner
mariner93315993_mariner
marker124420393_marker
marrer83716673_marrer
meager94515193mea_ger
mealier93015903mealier
meander1049973meander
meaners94415243mea_ners
meatier93214613meatier
mercer105214203me_rcer
merer75126233me_r_er
merger95016473me_rger
merrier92612303merrier
moaner84415113moa_ner
mourner938093mourner
neared75119803near_ed
nearlier836793nearlier
nearness838313nearness
neater64424313nea_ter
oleander936403oleander
oleaster837263oleaster
panner84224763_panner
pardner10239473_pardner
parer75839903_par_er
parker124121373_parker
parser84822373_parser
partner92811393_partner
pawner114212923_pawner
peacher144216073peacher
peakier134411443peakier
pearled10411543pearled
pearlers1039033pearlers
pearlier1037323pearlier
peatier94017233peatier
penner84616663pe_nner
perter84422283pe_rter
plainer93811983plainer
planer84122653pla_ner
planner93511623planner
pleader103511753plea_der
pleaser93912343plea_ser
pleater93916333plea_ter
pleather1356653pleather
prawner1246803prawner
quarter163211853quarter
rarer54731703_rar_er
reacher123718293reacher
reader73628293rea_der
readier83117423readier
realer63528593rea_ler
realter73716313realter
reamer84325213rea_mer
reannex1434733reannex
reaper84223143rea_per
reared75930013rear_ed
rearers74323563rear_ers
rearmed103912823rearmed
reasoner849343reasoner
reaver94524733rea_ver
reearned948883reearned
refiner105316913refiner
regainer9249353regainer
relearned1035633relearned
remarker14178493remarker
reorder8239483reorder
repiner94816903repiner
retainer82913813retainer
retarder9229433retarder
returner8397983returner
rewarder12208233rewarder
roarer63914333roar_er
saner54334323_sa_ner
scanner94411813scanner
scarcer113911373scarcer
scarer84524603scar_er
scarfer124511083scarfer
scarier94017873scarier
scarper114814823scarper
scorner9259763scorner
sealer63928963sea_ler
seamer84223613sea_mer
seamier93114633seamier
searcher13209103searcher
seared75232843sear_ed
seasoner857693seasoner
seater64534153sea_ter
seiner64622483se_iner
serener73415753serener
serer55935503se_r_er
serger73819733se_rger
server94917713se_rver
sharer95025483shar_er
sharker144313813sharker
sharper124312703sharper
shearer104414683shear_er
sleazier1735123sleazier
smarter94113133smarter
smearer94110403smear_er
smearier1036953smearier
snarer64620843snar_er
snarler73610633snarler
soarer64522243soar_er
sorner64720393_sorner
spanner94312563spanner
sparer84524963spar_er
sparger103613083sparger
sparker133914363sparker
sparser94311483sparser
spawner12347363spawner
spearer93913663spear_er
spurner9269653spurner
stainer73614923stainer
starer64027363star_er
starker114114693starker
starter73817883starter
starver104611993starver
sterner7411913sterner
swarmer1247803swarmer
swearer10349953swear_er
tanner63722283_tanner
tarter64023563_tarter
teacher123714833teacher
teared75722153tear_ed
tearers75218233tear_ers
teaser65421523tea_ser
teener64717503te_ener
tenner64117103te_nner
tenoner739683tenoner
termer85717253te_rmer
terne56426153te_rne_
ternes65422903te_rnes
terrier73414963terrier
terser67317823te_rser
trainer73316793trainer
turner63914613_turner
unearned9310063unearned
unlearned1035653unlearned
vainer93714573_vainer
vanner94215843_vanner
varier94619353_varier
vealer94016543vea_ler
vealier102712173vealier
veiner94514753ve_iner
verger104315693ve_rger
verier94620963ve_rier
vernier102711273ve_rnier
verser94516963ve_rser
wanner94019623_wanner
warder104020273_warder
warier93722893_warier
warmer113816733_warmer
warned104018913_warned
warners103315563_warners
warper114015583_warper
weakener1534913weakener
weaker134015443wea_ker
weaned103816153wea_ned
weaners104613833wea_ners
wearers104615903wear_ers
wearied112911803wearied
wearies103020223wearies
weather133513223weather
weaver123916613wea_ver
weiner94214133we_iner
weirder1144923weirder
yarder103813973_yarder
yarer84321573_yar_er
yarned105514023_yarned
yarners104312203_yarners
yawner12428473_yawner
yeaned103813903yea_ned
yearend11285703yearend
yearn86316433yearn__
yearns9509543yearn_s

Search took 8 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 Filter1786911340270.1401276364.3
2DLD Change Limit1340275317.01619103.1
3Display Results5315310.1862854.8
 (SQL Overall)1786915317.34224338.2
 
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.