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

147 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
planer8412265(None) 
placer105117741placer
plainer93811981plainer
planar84212711planar
plane74929141plane_
planed94420911planed
planers94517941planers
planes85028081planes
planet84228351planet
planner93511621planner
planter94017801planter
plater84427691plater
player115215211player
alane56135612alane_
aliner65621982aliner
almner85710722almner
blader93618582blader
blamer104417142blamer
blander103715162blander
blanker134612022blanker
blazer174414022blazer
caner75334772_caner
clanger104113492clanger
claver113816972claver
clawer114512782clawer
cleaner93712302cleaner
cloner84418092cloner
elater64724202elater
flaker134916172flaker
flamer114919122flamer
flanes94522422flanes
flaneur1034182flaneur
flanger113412622flanger
flanker143911292flanker
flayer124713562flayer
glancer103710072glancer
glazer164212262glazer
gleaner8379772gleaner
inaner62213542inaner
lacer75833752_lacer
lader65633722_lader
lager65132862_lager
laker95432872_laker
lamer75233702_lamer
lancer84319972_lancer
lander74028482_lander
lane45153322_lane_
lanes54946792_lanes
lanker104123002_lanker
lanner64920602_lanner
laser54633322_laser
later54843922_later
laver85031792_laver
laxer125420332_laxer
layer84626472_layer
leaner64022192leaner
liner55938922_liner
loaner64416502loaner
loner55431042_loner
meaner84617842meaner
moaner84415112moaner
pacer96131612p_acer
pager84728202p_ager
palaver1238752palaver
paler75436932p_aler
palier85023562palier
palmer105816542palmer
palter84423262palter
pander93725522p_ander
pane64950282p_ane_
paned85437182p_aned
panel76023622p_anel
panes76148692p_anes
panier84425502p_anier
panner84224762panner
panzer174213232p_anzer
paper95128662p_aper
parer75839902p_arer
pater74740722p_ater
paver104225832p_aver
pawer104422972p_awer
pawner114212922pawner
payer105125722p_ayer
penner84616662penner
pilsner935342pilsner
pinner84521502pinner
place94824612place_
placed114318002placed
placers114515262placers
places104323702places
placet103923672placet
plage84520402plage_
plages94520152plages
plaguer10328272plaguer
plained103812232plained
plaiter93615392plaiter
plan65833942plan__
planch133711442planch
planets93914082planets
plank115221142plan_k
planked143512282planked
planks124116752planks
plankter1435362plankter
planned103810152planned
planners10399932planners
plans75731272plan_s
plant75437112plan_t
plantar9369992plantar
planted103516122planted
planters102915322planters
plants84921802plants
plasher124215032plasher
plaster93318692plaster
plate74635112plate_
plated95225772plated
platen84518202platen
platers93924092platers
plates85432242plates
platier93716292platier
platter93917412platter
played124815032played
players124313762players
pleader103511752pleader
pleaser93912342pleaser
pleater93916332pleater
plier75221282pl_ier
plinker134010962plinker
plover115312612plover
plower114315062plower
plunder103810492plunder
plunger104211232plunger
plunker133910642plunker
plyer106214332pl_yer
prancer113613382prancer
prater84825352prater
prawner1246802prawner
prayer114815292prayer
pruner83413452pruner
punner84918152punner
saner54334322_saner
slaker104219272slaker
slander84015442slander
slater64429182slater
slaver94419612slaver
slayer93916332slayer
uplander1145532uplander
weaner93816772weaner

Search took 5 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 Filter178691825510.1101624463.6
2DLD Change Limit825511474.42318664.0
3Display Results1471470.0463195.7
 (SQL Overall)1786911474.57939024.0
 
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.