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

136 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
placer10511774(None) 
lacer75833751_lacer
pacer96131611p_acer
place94824611place_
placed114318001placed
placers114515261placers
places104323701places
placet103923671placet
planer84122651planer
plater84427691plater
player115215211player
blacker154513512blacker
blader93618582blader
blamer104417142blamer
blazer174414022blazer
bracer104620582bracer
clacker153813772clacker
claver113816972claver
clawer114512782clawer
elater64724202elater
facer105525052_facer
flaker134916172flaker
flamer114919122flamer
flayer124713562flayer
glace87420152glace_
glaces94218022glaces
glacier103911292glacier
glancer103710072glancer
glazer164212262glazer
lace66848472_lace_
laced87132642_laced
lacers85225252_lacers
laces76141762_laces
lacey105820912_lacey
lacier84020092_lacier
lacker125325622_lacker
lader65633722_lader
lager65132862_lager
laker95432872_laker
lamer75233702_lamer
lancer84319972_lancer
laser54633322_laser
later54843922_later
laver85031792_laver
laxer125420332_laxer
layer84626472_layer
macer912126942_macer
pace86345772p_ace_
paced106931682p_aced
pacers105124542p_acers
paces96741112p_aces
pacey126720282p_acey
pacier105018682p_acier
packer144223402p_acker
pager84728202p_ager
palace104516912palace_
palaced124110772palaced
palaces114216452palaces
palaver1238752palaver
paler75436932p_aler
palier85023562palier
palmer105816542palmer
palter84423262palter
paper95128662p_aper
parer75839902p_arer
pater74740722p_ater
paver104225832p_aver
pawer104422972p_awer
payer105125722p_ayer
peace95026082peace_
peaced115818912peaced
peaces106324082peaces
peacher144216072peacher
piecer105213082piecer
pincer104019172pincer
placard1236782placard
placater1238012placater
placebo1343292placebo
placets113911222placets
placid114012542placid
plack135017842plac_k
placket15412872placket
placks144414152placks
plage84520402plage_
plages94520152plages
plaguer10328272plaguer
plaice10311552plaice_
plaices11411142plaices
plainer93811982plainer
plaiter93615392plaiter
planar84212712planar
plane74929142plane_
planed94420912planed
planers94517942planers
planes85028082planes
planet84228352planet
planner93511622planner
planter94017802planter
plasher124215032plasher
plaster93318692plaster
plate74635112plate_
plated95225772plated
platen84518202platen
platers93924082platers
plates85432242plates
platier93716292platier
platter93917412platter
played124815032played
players124313762players
pleader103511752pleader
pleaser93912342pleaser
pleater93916332pleater
plier75221282pl_ier
plover115312612plover
plower114315062plower
plucker15368242plucker
plyer106214332pl_yer
poacher143912322poacher
policer113112682policer
prancer113613382prancer
prater84825352prater
prayer114815292prayer
pricer103918292pricer
racer75233022_racer
replacer12279742replacer
slacker133915292slacker
slaker104219272slaker
slater64429182slater
slaver94419612slaver
slayer93916332slayer
slicer84117602slicer
solacer93011102solacer
spacer104917792spacer
splicer114710522splicer
tracer84820232tracer
ulcer7310752ul_cer

Search took 3 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 Limit825511362.22037185.1
3Display Results1361360.0462956.5
 (SQL Overall)1786911362.37675206.6
 
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.