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

188 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
landers8402621(None) 
banders104324561banders
danders93921181danders
ganders93521701ganders
glanders103811501glanders
handers114224331handers
ladders94115171ladders
laders74927761la_ders
lancers93616641lancers
lander74028481lander_
landlers94312831landlers
lanners73618321lanners
larders83516941larders
lauders84012891lauders
launders9358741launders
lenders84419641lenders
panders103423731panders
sanders84025941sanders
slanders94014011slanders
wanders114221331wanders
zanders173015791zanders
adders84315702_adders
aiders74524632_aiders
alders74218422_alders
angers75222542_angers
bander93928222bander_
bangers104020352bangers
bankers133919092bankers
banners94018712banners
banters94623112banters
benders104021062benders
bilanders1235962bilanders
binders103920742binders
bladders12397802bladders
bladers104214682bla_ders
blander103715162blander_
blenders115210992blenders
blinders113911142blinders
blunders113911332blunders
bonders104120662bonders
branders114313092branders
cancers114018582cancers
candlers114214102candlers
candors104216762candors
caners84629192can_ers
cankers134418752cankers
canners93822662canners
canoers94318372canoers
canters94827722canters
carders104820352carders
cinders104617752cinders
clangers114312342clangers
colanders1238012colanders
dancers103413092dancers
dander811222992dander_
dandlers103912052dandlers
dangers94818212dangers
daunders10278472daunders
enders74324052_enders
faders105117462fa_ders
fanners103914652fanners
fenders113717262fenders
finders113717872finders
flangers123311372flangers
flankers15349302flankers
flinders12439262flinders
funders113813932funders
gadders103611502gadders
gander84322762gander_
gangers94418602gangers
genders93616782genders
glancers11408002glancers
glandes95413832glande_s
hander104526432hander_
handlers124014142handlers
hangers113120812hangers
hankers144218132hankers
hinders113718502hinders
inlanders1036122inlanders
islanders1035282islanders
laagers83411252laagers
lacers85225252la_cers
lackers134120542lackers
ladder84617622ladder_
ladens74516232la_dens
lader65633722la_der_
lades65141272la_de_s
ladlers84613562ladlers
lagers74826142la_gers
laggers94216242laggers
lakers105225152la_kers
lambers113817102lambers
lampers113817332lampers
lancer84319972lancer_
lances84824102lance_s
lancets93411162lancets
lanciers10308542lanciers
landaus8310342landaus
landed84619242lande_d
landler84113202landler_
landless94011172landless
lands65426902land__s
lanes54946792lan_e_s
langurs889102langurs
lanker104123002lanker_
lanner64920592lanner_
lantern7310012lantern
lanterns838302lanterns
lappers113717462lappers
lapsers93911052lapsers
larder73720972larder_
larkers113014512larkers
lasers64925702la_sers
lashers104121832lashers
lasters75627692lasters
lathers104321882lathers
lauder73815012lauder_
launder8309142launder_
laveers10329362laveers
lavenders1334752lavenders
lavers94526362la_vers
lawyers13377152lawyers
layers93921182la_yers
leaders83819602leaders
leaners73718172lean_ers
lender73921272lender_
lindens839412lindens
liners65428842lin_ers
lingers84223292lingers
linkers114317702linkers
linters73822612linters
loaders83413412loaders
loaners73913622loan_ers
loners64225802lon_ers
longers84819532longers
lungers83817082lungers
lunkers113414602lunkers
madders113513212madders
malanders1237022malanders
mangers103521262mangers
manners93417832manners
maunders11348342maunders
meanders1168832meanders
menders103818802menders
minders103720112minders
oleanders1035572oleanders
padders113312872padders
pander93725522pander_
paniers94717332paniers
panners93621272panners
panzers184012012panzers
pinders103720472pinders
planers94517942plan_ers
planners10399932planners
planters102915322planters
plunders11329822plunders
ponders103618842ponders
raiders84615142raiders
rangers83621042rangers
rankers113217462rankers
ranters73323642ranters
renders83821672renders
sander74828532sander_
sangers84421942sangers
senders83022352senders
slander84015442slander_
solanders1036962solanders
sonders83820712sonders
standers93514302standers
sunders84120052sunders
tandems1037632tandems
tankers113416912tankers
tanners74018392tanners
tenders83719722tenders
tinders84219172tinders
uplanders1234852uplanders
vanners103612842vanners
venders113717002venders
wadders123812442wadders
waders109120642wa_ders
wander104423712wander_
wankers144514712wankers
wanters104420092wanters
warders113416812warders
winders113721262winders
wonders113315992wonders
yarders113211592yarders
zander163417112zander_

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 Filter1786911076710.250714764.0
2DLD Change Limit1076711883.34332207.9
3Display Results1881880.0802350.0
 (SQL Overall)1786911883.67348649.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.