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

192 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
playlet123952(None) 
playlets1334901playlets
flatlet10312252flatlet
palet74650802p_a_let
pallet84232652p_allet
placet103923672pla_cet
placket15412872placket
planet84228352pla_net
plantlet10310012plantlet
platelet10510732platelet
playact1446552playact
played124815032play_ed
player115215212play_er
playless1334862playless
playlist1347572playlist
playpen1434692playpen
aglet65534143__aglet
ballet84733973_ballet
blanket134313093blanket
cablet104429463_cablet
callet84536763_callet
camlet104426583_camlet
caplet104226813_caplet
chalet113825993cha_let
chaplet14512253chaplet
claret84026573cla_ret
clayed125013043clay_ed
clayey14407663clay_ey
clayier1248323clayier
clayiest1337923clayiest
daylit10512493_daylit
eaglet73722583_eaglet
epaulet939513epaulet
flailed1137303flailed
flasket1439733flasket
flatlets1147373flatlets
flayed134414053flay_ed
flayer124713563flay_er
gallet73630853_gallet
glaiket1238363glaiket
hamlet113722793_hamlet
haslet93222713_haslet
kayles134712003_kayles
labret8320223_labret
ladle66320443_ladle_
ladled85013483_ladled
ladler74314933_ladler
ladles74619543_ladles
lalled74218753_lalled
lancet84223573_lancet
lappet103817733_lappet
layed95127383_lay_ed
layer84626473_lay_er
laymen113010843_laymen
layout9513703_layout
leaflet10199743leaflet
mallet84433053_mallet
packet144726503p_acket
padle84522343p_adle_
padles95221123p_adles
pale66055013p_a_le_
palea75028663p_a_lea
paled85538723p_a_led
paler75436933p_a_ler
pales75753803p_a_les
palest83926223p_a_lest
palets85122313p_a_lets
palled94625163p_alled
pallets93919303p_allets
parget94529393p_arget
parle75836163p_arle_
parled94626293p_arled
parles86334403p_arles
parley116718363p_arley
partlet92720363partlet
payed115925933p_ay_ed
payee105524723p_ay_ee
payees114812903p_ayees
payer105125723p_ay_er
payment14310703p_ayment
payout11714653p_ayout
pealed95322813pea_led
pearled10411553pearled
pearler9310373pearler
pellet83326553p_ellet
phyle134111153p_hyle_
piglet93420923p_iglet
piolet83225643p_iolet
placate11312433placate
place94824613pla_ce_
placed114318003pla_ced
placer105117743pla_cer
places104323703pla_ces
placets113911223pla_cets
plackets1646583plackets
plage84520403pla_ge_
plages94520153pla_ges
plague93610853plague_
plagued11307473plagued
plaguer10328273plaguer
plagues103311063plagues
plaguey13335943plaguey
plaice10311553plaice_
plaices11411143plaices
plaided11409643plaided
plained103812233plained
plainer93811983plainer
plainest10313613plainest
plaint85323203pla_int
plait75631573pla__it
plaited103713893plaited
plaiter93615393plaiter
planate9314573planate
planchet152511963planchet
plane74929143pla_ne_
planed94420913pla_ned
planer84122653pla_ner
planes85028083pla_nes
planets93914083pla_nets
plangent1138803plangent
planked143512283planked
planless1036813planless
planned103810153planned
planner93511623planner
plant75437113pla__nt
planted103516123planted
planter94017803planter
plantlets1145013plantlets
plaque17317643plaque_
plaques18317893plaques
plashed133712643plashed
plasher124215033plasher
plashes124417393plashes
plaster93318693plaster
plat66048873pla___t
plate74635113pla_te_
plated95225773pla_ted
platelets1165763platelets
platen84518203pla_ten
plater84427693pla_ter
plates85432243pla_tes
platier93716293platier
platies93722543platies
platiest103216093platiest
platted103614263platted
platter93917413platter
plaudit1046253plaudit
play95928983play___
playa105812943play__a
playable15137923playable_
playacts1543813playacts
playas114612283play_as
playboy1743813playboy
playdate1465263playdate
playday1643823playday
players124313763players
playful1544653playful
playgoer1443533playgoer
playing133816093playing
playland1444573playland
playlike1735613playlike
playlists1444783playlists
playmate1566463playmate
playoff1843533playoff
playpens1534073playpens
plays106320773play__s
playsuit1343773playsuit
playwear1642103playwear
pledget113510653pledget
pliable111610323pliable_
ployed124310563ploy_ed
plumelet1276173plumelet
plummet13278353plummet
plyer106214333pl_y_er
praelect1247533praelect
prayed124815433pray_ed
prayer114815293pray_er
pullet84026333p_ullet
sallet63734543_sallet
samlet84126563_samlet
scarlet91516943scarlet
slayed104716223slay_ed
slayer93916333slay_er
splayed13357813splay_ed
splayfeet1752053splayfeet
starlet71620123starlet
stylet94018573_stylet
tablet84227643_tablet
valet84337873_va_let
varlet9423503_varlet
vilayet1348533vilay_et
wallet93327093_wallet

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 Limit1340271925.73323378.2
3Display Results1921920.0762526.3
 (SQL Overall)1786911926.21528751.6
 
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.