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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
planters10291533(None) 
plaiters103512631plaiters
planers94517951plan_ers
plankters1544581plankters
planners10399941planners
planter94017811planter_
plasters103518131plasters
platers93924091pla_ters
platters103415281platters
banters94623122_banters
blasters104116142blasters
blatters104414092blatters
canters94827732_canters
chanters134016742chanters
clangers114312342clangers
clatters103313912clatters
elaters74420192ela_ters
flangers123311372flangers
flankers15349302flankers
flatters113814202flatters
flaunters1234512flaunters
glancers11408002glancers
glanders103811512glanders
granters93614152granters
implanters1484152implanters
lancers93616642_lancers
landers84026222_landers
lanners73618332_lanners
lantern7310012_lantern
lanterns838302_lanterns
lasters75627692_lasters
linters73822632_linters
painters103013032painters
palters94021682p_alters
panders103423742p_anders
paniers94717332p_aniers
panners93621272p_anners
panthers13510782p_anthers
panzers184012012p_anzers
pasters94531732p_asters
paters84935842p_a_ters
patters94825192p_atters
piasters102912812piasters
pilasters1138222pilasters
placaters1336472placaters
placers114515262pla_cers
plaguers11286502plaguers
plaisters1137812plaisters
plaiter93615392plaiter_
planer84122662plan_er_
planes85028082plan_e_s
planets93914082plan_ets
plankter1435362plankter_
planless1036822planless
planner93511632planner_
plantar9369992plantar_
planted103516122plante_d
plantlets1145022plantlets
plants84921802plant__s
plashers133813452plashers
plaster93318692plaster_
plastery13279702plastery
platens94213982pla_tens
plater84427692pla_ter_
plates85432242pla_te_s
platter93917412platter_
players124313762pla_yers
pleaters103613792pleaters
plinkers14309402plinkers
plotters104011552plotters
plunders11329842plunders
plungers11379412plungers
plunkers14328342plunkers
pointers103013722pointers
prancers123210342prancers
praters94921652pra_ters
printers103214912printers
psalters10227712psalters
punters93617052p_unters
ranters73323642_ranters
slanders94014022slanders
slaters73123732sla_ters
splatters11327542splatters
splinters11277922splinters
uplanders1234862uplanders
wanters104420092_wanters

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 Filter1786911210590.420425454.8
2DLD Change Limit121059864.06329795.5
3Display Results86860.0332606.1
 (SQL Overall)178691864.51639568.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.