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

151 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
placed11431800(None) 
laced87132641_laced
paced106931681p_aced
palaced124110771palaced
peaced115818911peaced
place94824611place_
placer105117741placer
places104323701places
placet103923671placet
placid114012541placid
planed94420911planed
plated95225771plated
played124815031played
aced79540882__aced
alated75625142alated
belaced124112152belaced
blacked163613372blacked
bladed104717762bladed
blamed116017952blamed
blared95018242blared
blawed124713892blawed
blazed184314712blazed
braced115420602braced
clacked164113602clacked
clawed125115072clawed
clayed125013042clayed
elated74725822elated
emplaced1536052emplaced
enlaced102410522enlaced
faced117727652_faced
flacked173711582flacked
flaked144715652flaked
flamed124618972flamed
flared105317602flared
flawed134712722flawed
flayed134414052flayed
glace87420152glace_
glaceed1136192glaceed
glaces94218022glaces
glanced11439232glanced
glared84715192glared
glazed174711772glazed
graced105217902graced
inlaced10239872inlaced
lace66848472_lace_
lacer75833752_lacer
laces76141762_laces
lacey105820912_lacey
lacked135324652_lacked
laded74232612_laded
laked105731122_laked
lamed85235292_lamed
lanced93717722_lanced
lased65132342_lased
lated65240672_lated
laved95028592_laved
lawed96028322_lawed
layed95127382_layed
lazed154925842_lazed
maced108528692_maced
pace86345772p_ace_
pacer96131612p_acer
paces96741112p_aces
pacey126720282p_acey
packed154822602p_acked
paged95926782p_aged
palace104516912palace_
palaces114216452palaces
paled85538722p_aled
palled94625162palled
palmed114314642palmed
palped114513642palped
paned85437182p_aned
pared86946762p_ared
pated85237842p_ated
paved115525262p_aved
pawed115725612p_awed
payed115925932p_ayed
peace95026082peace_
peaces106324082peaces
peached154315882peached
peaked136117402peaked
pealed95322812pealed
phased124011972phased
pieced113912102pieced
placard1236782placard
placated1338452placated
placebo1343292placebo
placers114515262placers
placets113911222placets
plack135017842plac_k
placket15412872placket
placks144414152placks
placoid1239772placoid
plage84520402plage_
plages94520152plages
plagued11307472plagued
plaice10311552plaice_
plaices11411142plaices
plaid85118302pla_id
plaided11409642plaided
plained103812232plained
plaited103713892plaited
plane74929142plane_
planer84122652planer
planes85028082planes
planet84228352planet
planked143512282planked
planned103810152planned
planted103516122planted
plashed133712642plashed
plate74635112plate_
platen84518202platen
plater84427692plater
plates85432242plates
platted103614262platted
player115215212player
pleached16338062pleached
pleaded113511262pleaded
pleased103712072pleased
pleated103816632pleated
pled75231432pl__ed
plied85118592pl_ied
plowed124213202plowed
ployed124310562ployed
plucked16367962plucked
plumed114412882plumed
poached154212402poached
policed123212232policed
ponced114314812ponced
pranced123714042pranced
prated94924922prated
prayed124815432prayed
priced115018882priced
raced87635312_raced
relaced103517212relaced
replaced133211402replaced
slacked143815452slacked
slaked114318272slaked
slated75028312slated
slaved104017042slaved
slayed104716222slayed
sliced94416312sliced
solaced102911062solaced
spaced114517252spaced
splayed13357812splayed
spliced124310592spliced
talced93811002talced
traced94821582traced
unlaced102913732unlaced
unplaced1338612unplaced

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.330541487.9
2DLD Change Limit825511512.18637763.5
3Display Results1511510.0463282.6
 (SQL Overall)1786911512.56269746.7
 
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.