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

403 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
learners839815(None) 
earners74016451_earners
leaners73718171lea_ners
learner7319381learner_
yearners11346371yearners
bearers94619592bear_ers
cleaners103610542clea_ners
clearers10349302clear_ers
clearness1135632clearness
darners83815772_darners
dearness939972dearness
earner63617222_earner_
fearers104815272fear_ers
garners83815982_garners
gleaners9348072glea_ners
hearers104319782hear_ers
lanners73618332l_anners
larders83516942l_arders
larkers113014512l_arkers
leachers133712812leachers
leaders83819602lea_ders
leaguers935062leaguers
leakers113415422lea_kers
leaner64022192lea_ner_
leanness837372leanness
leapers93716662lea_pers
learier73415662learier_
learned8329302learne_d
learns65513742learn__s
leasers74717842lea_sers
leathers114215082leathers
leavers103717782lea_vers
loaners73913622loa_ners
meaners94415242mea_ners
nearness838312nearness
pearlers1039032pearlers
rearers74323562rear_ers
tearers75218232tear_ers
warners103315562_warners
weaners104613832wea_ners
wearers104615902wear_ers
yarners104312202_yarners
yearner10336872yearner_
adorners9196623adorners
armers85520273__armers
awarders1245073awarders
banners94018713_banners
barbers114317503_barbers
barkers134318513_barkers
barneys12569563_barneys
barters94223033_barters
beaders104120183bea_ders
beakers134216873bea_kers
beanery1237563bea_nery
bearer85323913bear_er_
beaters94925043bea_ters
beavers124417323bea_vers
blarneys13183193blarneys
bleachers16297923bleachers
bleakness1543593bleakness
blearier1037333blearier_
bleariness1246053bleariness
bleaters103412323blea_ters
boarders11408623boarders
branners104010923branners
burners94115673_burners
caners84629203_ca_ners
canners93822663_canners
carders104820353_carders
careers95218783_careers
carers85133963_car_ers
carnets93918403_carnets
carneys124310543_carneys
carpers114521253_carpers
carters95327253_carters
carvers124817543_carvers
centners1057243centners
chargers144011323chargers
charmers154211333charmers
charnels13328173charnels
charters134115583charters
churners13316893churners
cleaner93712303clea_ner_
cleanness1144973cleanness
cleansers11335073cleansers
clearer93710823clear_er_
cleavers13398873clea_vers
corners94723313_corners
damners104112113_damners
darers75921873_dar_ers
darnels83710433_darnels
darner74017303_darner_
darters84017603_darters
deadeners1146283deadeners
deadness1039233deadness
deafness1236213deafness
dealers84118613dea_lers
deanery1137613dea_nery
dearer74822803dear_er_
dearies83526273dearie_s
debarkers16164553debarkers
deboners11268113deboners
decreers11277623decreers
decriers11299733decriers
definers124211193definers
dehorners1344743dehorners
derangers1136703derangers
detainers10269103detainers
drainers92811253drainers
eagers74523683_ea_gers
earless74316073_earless
earned74818333_earne_d
earnest7318733_earnest
earnests837853_earnests
earns55927563_earn__s
easters75125683_easters
eaters65535953_ea_ters
elaters74420193ela_ters
eloiners8128153eloiners
erasers74413943_erasers
ernes55224813_e_rne_s
eveners10109503_eveners
fanners103914653_fanners
farcers124713443_farcers
farers95924053_far_ers
farmers124315263_farmers
farness102912203_farness
fawners13388493_fawners
fearer94820183fear_er_
fearless1137873fearless
feasters11511563feasters
feathers143513243feathers
feigners1235483feigners
fernery1335813fe_rnery
gainers84214593_gainers
garner73917003_garner_
garnets84115403_garnets
garters84218233_garters
gearless937373gearless
gleamers11306563glea_mers
gleaner8379773glea_ner_
grainers93012073grainers
guarders1035883guarders
harmers124116593_harmers
harness102413933_harness
harpers124916203_harpers
headers113819393hea_ders
healers104319463hea_lers
heapers123616673hea_pers
hearer94323643hear_er_
hearkeners1743983hearkeners
hearkens15336693hearkens
hearses104414533hearse_s
hearteners1346213hearteners
heartens113010153heartens
heaters104225223hea_ters
heathers143914733heathers
heavers133717193hea_vers
herders113914123he_rders
hoarders12307433hoarders
jeerers14328923jeer_ers
jerkers18287083je_rkers
keeners113610783ke_eners
kernels11417953ke_rnels
kernes104717533ke_rne_s
laagers83411253l_aagers
lacers85225253l_a_cers
lackers134120543l_ackers
ladders94115173l_adders
laders74927763l_a_ders
ladlers84613573l_adlers
lagers74826143l_a_gers
laggers94216243l_aggers
lakers105225153l_a_kers
lambers113817113l_ambers
lampers113817333l_ampers
lancers93616643l_ancers
landers84026213l_anders
lanes54946793l_a_ne_s
lanner64920603l_anner_
lappers113717463l_appers
lapsers93911053l_apsers
larceners1135993l_arceners
larder73720973l_arder_
larees65323113l_ar_ees
lares54852633l_ar_e_s
larger74417513l_arger_
larges74824233l_arge_s
largess8408913l_argess
larker104519243l_arker_
lasers64925703l_a_sers
lashers104121833l_ashers
lasters75627693l_asters
lathers104321883l_athers
lauders84012893l_auders
launders9358743l_aunders
laveers10329363l_aveers
lavers94526363l_a_vers
lawyers13377153l_awyers
laxness1436043l_axness
layers93921183l_a_yers
leacher124014843leacher_
leaches123319343leache_s
leadens83610983lea_dens
leader74824653lea_der_
leadier83212723leadier_
leadless9248793leadless
leafier10329833leafier_
leafiness1236483leafiness
leafless11246573leafless
leaflets11244813leaflets
leaguer835793leaguer_
leagues837943league_s
leaker104620073lea_ker_
leakier114010993leakier_
leakiness1337503leakiness
leakless12246983leakless
leaned73422543lea_ne_d
leanest7415863lea_nest
leans55536253lea_n__s
leaper88118943lea_per_
leariest83117853leariest
learn55322663learn___
learnedly1342833learnedly
learning978553learning
learnings1094323learnings
learnt64019253learn__t
lears55938733lea___rs
leaser65322673lea_ser_
leases65428113lea_se_s
leashes103514403leashe_s
leather103815783leather_
leathern11398913leathern
leathery14438973leathery
leavens10409303lea_vens
leaver94321513lea_ver_
leaves94222383lea_ve_s
leavier10319993leavier_
lechers123313963le_chers
ledgers94912183le_dgers
leerier73111503leerier_
leeriness938323leeriness
leers54828983le___ers
legers74518313le__gers
legwarmers1671853legwarmers
leisters83312823leisters
lenders84419643le_nders
lenes54738523le__ne_s
leones64417723le_one_s
lepers84817323le__pers
letters73819853le_tters
levanters1254993levanters
levelers11259323levelers
levers94621323le__vers
leviers103510343le_viers
lewdness1254173lewdness
lianes63819323lia_ne_s
liernes739623lierne_s
limners93311563l_imners
liners65428853l__iners
liveners11217933liveners
loaders83413433loa_ders
loafers10349463loa_fers
loaner64416503loa_ner_
loathers113310443loathers
loners64225813l__oners
loriners839963loriners
lucarnes1045093lucarne_s
lurers64217493l_ur_ers
lurkers113910083l_urkers
manners93417833_manners
mariners103113863_mariners
markers133516103_markers
marrers93414313_marrers
meanders1168833meanders
meaner84617843mea_ner_
meanness1037183meanness
mercers114412773me_rcers
mergers103813423me_rgers
moaners92813553moa_ners
mourners1036913mourners
nearer64618893near_er_
neatness839153neatness
oleanders1035573oleanders
oleasters936733oleasters
panners93621273_panners
pardners11269193_pardners
parers85530743_par_ers
parkers133816873_parkers
parsers94118153_parsers
partners102711133_partners
pawners124311073_pawners
peachers153213843peachers
pearler9310373pearler_
pearter9412743pearter_
peartness1137773peartness
penners93414183pe_nners
planers94517943pla_ners
planners10399933planners
pleaders113210183plea_ders
pleasers104010293plea_sers
pleaters103613793plea_ters
pleathers1446453pleathers
prawners1346003prawners
quarters173110453quarters
reachers133515723reachers
readers83823773rea_ders
realness8410443realness
realters83614043realters
reamers94221083rea_mers
reapers93520453rea_pers
rearer64928913rear_er_
reasoners947113reasoners
reavers108320743rea_vers
refiners114713313refiners
regainers10237383regainers
remarkers15197283remarkers
reorders9198833reorders
repiners103913433repiners
retainers92510763retainers
retarders10227573retarders
returners9376553returners
rewarders13226453rewarders
roarers73812743roar_ers
scanners10379703scanners
scarers94618513scar_ers
scarfers13408463scarfers
scarpers124712513scarpers
scorners10228493scorners
sealers74323553sea_lers
seamers94719433sea_mers
searchers14197353searchers
searer65432023sear_er_
seasoners946263seasoners
seaters74028943sea_ters
seiners74219273se_iners
sergers83815633se_rgers
servers103214833se_rvers
sharers104720623shar_ers
sharkers154011053sharkers
sharpers133810943sharpers
shearers113911323shear_ers
smearers10308623smear_ers
snarers74216663snar_ers
snarlers8298753snarlers
soarers74118093soar_ers
sorners73416873_sorners
spanners103710773spanners
sparers94519613spar_ers
spargers11389733spargers
sparkers144111313sparkers
spawners13396493spawners
spearers103711143spear_ers
spurners10288493spurners
stainers83212173stainers
starers74522313star_ers
starkers123712393starkers
starters83714773starters
starvers11459643starvers
swarmers1346323swarmers
swearers11328583swear_ers
tanners74018393_tanners
teachers133212393teachers
tearer64822903tear_er_
tearier73815613tearier_
teariness9310633teariness
tearless848713tearless
teasers75317243tea_sers
teeners74415453te_eners
tenners74014923te_nners
tenoners858713tenoners
termers95414503te_rmers
ternes65422903te_rne_s
terriers84210823terriers
trainers83114643trainers
turners73912893_turners
vanners103612843_vanners
variers103712663_variers
vealers103214293vea_lers
veiners104112523ve_iners
vergers114412633ve_rgers
verniers11227843ve_rniers
versers103813523ve_rsers
warders113416813_warders
warmers124514293_warmers
warner93717223_warner_
warpers123413583_warpers
weakeners1644163weakeners
weakness1535353weakness
weaner93816773wea_ner_
wearer94319403wear_er_
wearier103613283wearier_
wearies103020223wearie_s
weariness1238843weariness
weathers143412833weathers
weavers133714463wea_vers
weiners103913063we_iners
yarders113211593_yarders
yarner93313063_yarner_
yawners13367183_yawners
yearends12234483yearends
yearned11327373yearne_d
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 Filter1786911461620.403443402.0
2DLD Change Limit1461624036.56322270.6
3Display Results4034030.1732329.5
 (SQL Overall)1786914037.13925030.3
 
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.