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

119 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
leaners7371817(None) 
cleaners103610541cleaners
gleaners9348071gleaners
leaders83819601leaders
leakers113415421leakers
leaner64022191leaner_
leapers93716661leapers
learners8398151learners
leasers74717841leasers
leavers103717781leavers
loaners73913621loaners
meaners94415241meaners
weaners104613831weaners
beaders104120182beaders
beakers134216872beakers
beanery1237562beanery
bearers94619592bearers
beaters94925042beaters
beavers124417322beavers
bleaters103412322bleaters
caners84629202_caners
cleaner93712302cleaner_
cleansers11335062cleansers
clearers10349302clearers
cleavers13398872cleavers
dealers84118612dealers
deanery1137612deanery
eagers74523682_eagers
earners74016452_earners
eaters65535952_eaters
elaters74420192elaters
fearers104815272fearers
gleamers11306562gleamers
gleaner8379772gleaner_
headers113819392headers
healers104319462healers
heapers123616672heapers
hearers104319782hearers
heaters104225222heaters
heavers133717192heavers
keeners113610782keeners
laagers83411252laagers
lacers85225252l_acers
laders74927762l_aders
lagers74826142l_agers
lakers105225152l_akers
lancers93616642l_ancers
landers84026212l_anders
lanes54946792l_ane_s
lanners73618332lanners
lasers64925702l_asers
lavers94526362l_avers
layers93921182l_ayers
leachers133712812leachers
leadens83610982leadens
leader74824652leader_
leaguers935062leaguers
leaker104620072leaker_
leaned73422542leane_d
leanest7415862leanest
leanness837372leanness
leans55536252lean__s
leaper88118942leaper_
learner7319382learner_
lears55938732lea__rs
leaser65322672leaser_
leases65428112lease_s
leathers114215082leathers
leavens10409302leavens
leaver94321512leaver_
leaves94222382leave_s
lechers123313962lechers
ledgers94912182ledgers
leers54828982le__ers
legers74518312le_gers
lenders84419642lenders
lenes54738522le_ne_s
leones64417722leone_s
lepers84817322le_pers
letters73819852letters
levanters1254992levanters
levers94621322le_vers
leviers103510342leviers
lianes63819322liane_s
limners93311562limners
liners65428852l_iners
loaders83413432loaders
loafers10349462loafers
loaner64416502loaner_
loners64225812l_oners
meanders1168832meanders
meaner84617842meaner_
moaners92813552moaners
oleanders1035572oleanders
penners93414182penners
planers94517942planers
pleaders113210182pleaders
pleasers104010292pleasers
pleaters103613792pleaters
readers83823772readers
reamers94221082reamers
reapers93520452reapers
rearers74323562rearers
reavers108320742reavers
sealers74323552sealers
seamers94719432seamers
seaters74028942seaters
seiners74219272seiners
tearers75218232tearers
teasers75317242teasers
teeners74415452teeners
tenners74014922tenners
vealers103214292vealers
veiners104112522veiners
weaner93816772weaner_
wearers104615902wearers
weavers133714462weavers
weiners103913062weiners
yearners11346372yearners

Search took 6 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 Filter1786911076710.373479064.3
2DLD Change Limit1076711195.11021070.6
3Display Results1191190.0761565.8
 (SQL Overall)1786911195.55932144.5
 
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.