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

107 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
placers11451526(None) 
lacers85225251_lacers
pacers105124541p_acers
placer105117741placer_
places104323701place_s
placets113911221placets
planers94517941planers
platers93924091platers
players124313761players
bladers104214682bladers
blamers115314212blamers
blazers184811682blazers
bracers114616702bracers
clackers163911702clackers
clavers124314902clavers
clawers123910972clawers
elaters74420192elaters
facers115519442_facers
flakers143613272flakers
flamers124616362flamers
flayers133912032flayers
glaces94218022glace_s
glaciers11277892glaciers
glancers11408002glancers
glazers174410042glazers
lacer75833752_lacer_
laces76141762_lace_s
lackers134120542_lackers
laders74927762_laders
lagers74826142_lagers
lakers105225152_lakers
lancers93616642_lancers
lasers64925702_lasers
lavers94526362_lavers
layers93921182_layers
macers105321272_macers
pacer96131612p_acer_
paces96741112p_ace_s
packers153818892p_ackers
pagers94423252p_agers
palaces114216452palace_s
palavers1337992palavers
palmers113513622palmers
palters94021682palters
papers105125322p_apers
parers85530742p_arers
paters84935832p_aters
pavers115021822p_avers
pawers114818782p_awers
payers114621822p_ayers
peaces106324082peace_s
peachers153213842peachers
piecers114112252piecers
pincers113916502pincers
placard1236782placard
placards1345812placards
placaters1336472placaters
place94824612place__
placebo1343292placebo
placebos1443712placebos
placed114318002place_d
placet103923672place_t
plackets1646582plackets
placks144414152plac_ks
plages94520152plage_s
plaguers11286502plaguers
plaices11411142plaice_s
plaiters103512632plaiters
planer84122652planer_
planes85028082plane_s
planets93914082planets
planners10399932planners
planters102915322planters
plashers133813452plashers
plasters103518132plasters
platens94213982platens
plater84427692plater_
plates85432242plate_s
platters103415282platters
player115215212player_
pleaders113210182pleaders
pleasers104010292pleasers
pleaters103613792pleaters
pliers84715152pl_iers
plovers123611832plovers
plowers123812242plowers
pluckers16316552pluckers
plyers114912982pl_yers
poachers152910762poachers
policers12259992policers
prancers123210332prancers
praters94921652praters
prayers124212852prayers
pricers113915062pricers
racers84725432_racers
replacers13266832replacers
slackers143812742slackers
slakers114115752slakers
slaters73123732slaters
slavers103716502slavers
slayers104513322slayers
slicers94114922slicers
solacers10268892solacers
spacers113813872spacers
splicers12338112splicers
tracers94917842tracers
ulcers839382ul_cers

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.390458182.1
2DLD Change Limit1076711072.87337476.9
3Display Results1071070.0502140.0
 (SQL Overall)1786911073.31353936.3
 
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.