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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

168 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
playpen143469(None) 
playpens1534071playpens
claypan1434312claypan
laymen113010842_laymen
platen84518202pla_ten
played124815032play_ed
player115215212play_er
playlet1239522playlet
plumpen13276402plumpen
arpen74418043__arpen
aspen75216093__aspen
baymen134212003_baymen
blacken15439793blacken
blype12429673bl_ype_
blypes13357543bl_ypes
clamped144012043clamped
clamper134012993clamper
clapped143511173clapped
clapper134011863clapper
clasped123610443clasped
clasper113811863clasper
clayed125013043clay_ed
clayey14407663clay_ey
clayier1248323clayier
claypans1543873claypans
clypei1334163cl_ypei
dampen114310593_dampen
draymen1335233draymen
flagmen13226913flagmen
flamen115215993fla_men
flanken14226763flanken
flapped15328253flapped
flapper14359203flapper
flatten10429653flatten
flaxen16518573fla_xen
flayed134414053flay_ed
flayer124713563flay_er
flymen14387773fl_ymen
gladden10376313gladden
happen134812193_happen
laden65022193_la_den
lamped114017543_lamped
lapel73716683_la_pel
lapin75222923_la_pin
lapped114320033_lapped
lapper104319953_lapper
lappet103817723_lappet
lateen64014863_lateen
laten54328343_la_ten
latten65018203_latten
lawmen11308593_lawmen
layed95127383_lay_ed
layer84626473_lay_er
layin84720333_lay_in
layman113511303_layman
lippen103911403_lippen
loupen84510293_loupen
lumpen104010663_lumpen
palped114513643p_alped
pampean1335543p_ampean
pamper124316663p_amper
pangen94115913p_angen
paper95128663p_a_per
paten74827343p_a_ten
patten84418193p_atten
pauper103511943p_auper
payed115925933p_ay_ed
payee105524723p_ay_ee
payees114812903p_ayees
payer105125723p_ay_er
payment14310703p_ayment
peahen113410133pea_hen
peasen84815963pea_sen
pigpen1136583p_igpen
place94824613pla_ce_
placed114318003pla_ced
placemen1445783placemen
placer105117743pla_cer
places104323703pla_ces
placet103923673pla_cet
placket15412873placket
plage84520403pla_ge_
plages94520153pla_ges
plague93610853plague_
plagued11307473plagued
plaguer10328273plaguer
plagues103311063plagues
plaguey13335943plaguey
plaice10311553plaice_
plaices11411143plaices
plaided11409643plaided
plain74823303pla__in
plained103812233plained
plainer93811983plainer
plaited103713893plaited
plaiter93615393plaiter
plan65833943pla___n
plane74929143pla_ne_
planed94420913pla_ned
planer84122653pla_ner
planes85028083pla_nes
planet84228353pla_net
plangent1138803plangent
planked143512283planked
planned103810153planned
planner93511623planner
planted103516123planted
planter94017803planter
plaque17317643plaque_
plaques18317893plaques
plashed133712643plashed
plasher124215033plasher
plashes124417393plashes
plasmin112410033plasmin
plasmon11257983plasmon
plaster93318693plaster
platan83913693pla_tan
platane93112303platane
plate74635113pla_te_
plated95225773pla_ted
platens94213983pla_tens
plater84427693pla_ter
plates85432243pla_tes
platier93716293platier
platies93722543platies
platoon938953platoon
platted103614263platted
platter93917413platter
platypi1442753platyp_i
platypus1542353platypus
play95928983play___
playa105812943play__a
playact1446553playact
playas114612283play_as
playboy1743813playboy
playday1643823playday
playdown1743593playdown
players124313763players
playful1544653playful
playgoer1443533playgoer
playing133816093playing
playland1444573playland
playless1334863playless
playlets1334903playlets
playoff1843533playoff
plays106320773play__s
playwear1642103playwear
plopped11288773plopped
plowmen1434883plowmen
ployed124310563ploy_ed
plumped14318643plumped
plumpens14304953plumpens
plumper13318773plumper
plyer106214333pl_y_er
polyped1537173polyped
prayed124815433pray_ed
prayer114815293pray_er
rappen103512713_rappen
shapen114414653sha_pen
sharpen12389723sharpen
slacken13399933slacken
slapped123511843slapped
slapper113512463slapper
slayed104716223slay_ed
slayer93916333slay_er
slype105112363sl_ype_
slypes114410483sl_ypes
splayed13357813splay_ed

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271686.29621287.6
3Display Results1681680.0632666.7
 (SQL Overall)1786911686.76526414.0
 
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.