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

93 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
players12431376(None) 
flayers133912031flayers
layers93921181_layers
payers114621821p_ayers
placers114515261placers
planers94517941planers
platers93924091platers
player115215211player_
plyers114912981pl_yers
prayers124212851prayers
slayers104513321slayers
allayers11156632allayers
belayers13298142belayers
bilayers13296922bilayers
bladers104214682bladers
blamers115314212blamers
blazers184811682blazers
brayers124511902brayers
clavers124314902clavers
clawers123910972clawers
delayers12268662delayers
elaters74420192elaters
flakers143613272flakers
flamers124616362flamers
flayer124713562flayer_
flyers125712802fl_yers
glazers174410042glazers
hayers124415942_hayers
inlayers1135642inlayers
lacers85225252_lacers
laders74927762_laders
lagers74826142_lagers
lakers105225152_lakers
lasers64925702_lasers
lavers94526362_lavers
lawyers13377152_lawyers
layer84626472_layer_
pacers105124542p_acers
pagers94423252p_agers
palavers1337992palavers
palmers113513622palmers
palters94021682palters
papers105125322p_apers
parers85530742p_arers
paters84935832p_aters
pavers115021822p_avers
pawers114818782p_awers
payees114812902p_ayees
payer105125722p_ayer_
payors114312642p_ayors
placer105117742placer_
places104323702place_s
placets113911222placets
plages94520152plage_s
plaguers11286502plaguers
plaiters103512632plaiters
planer84122652planer_
planes85028082plane_s
planets93914082planets
planners10399932planners
planters102915322planters
plashers133813452plashers
plasters103518132plasters
platens94213982platens
plater84427692plater_
plates85432242plate_s
platters103415282platters
playas114612282play_as
played124815032playe_d
playgoers1543192playgoers
playless1334862playless
playlets1334902playlets
playpens1534072playpens
plays106320772play__s
pleaders113210182pleaders
pleasers104010292pleasers
pleaters103613792pleaters
pliers84715152pl_iers
plovers123611832plovers
plowers123812242plowers
plyer106214332pl_yer_
praters94921652praters
prayer114815292prayer_
preyers124412362preyers
pryers115012242p_ryers
sayers94221592_sayers
slakers114115752slakers
slaters73123732slaters
slavers103716502slavers
slayer93916332slayer_
sprayers13367052sprayers
stayers103813632stayers
swayers13398852swayers

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.376475242.0
2DLD Change Limit107671933.28032826.5
3Display Results93930.0332818.2
 (SQL Overall)178691933.68948438.9
 
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.