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

154 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
pillory1224745(None) 
pillowy15316421pillowy
billowy15366902billowy
pallor8313672pallor_
pallors9314362pallors
pillar8314022pillar_
pillars9313492pillars
pillow113110572pillo_w
pillows122610122pillows
willowy16276352willowy
alloy85519973_allo_y
apiology1436563apiology
axillary18235103axillary
biliary1238213biliary
biller84923483biller_
billers94720833billers
billon83713833billo_n
billons93013363billons
billow114111223billo_w
billows123611293billows
billy105525363bill__y
biology1337363biology
calory11312843_calory
capillary16134263capillary
ciliary1247923ciliary
dilatory12279273dilatory
dilly94923783dill__y
filler94623623filler_
fillers104320213fillers
fillo84319783fillo__
fillos94415083fillo_s
filly114424903fill__y
fullery13337973fullery
gallery11468743gallery
giller74519733giller_
gillers84216903gillers
gilly94321633gill__y
glory96413293__glory
grillery12355503grillery
hellery13329213hellery
hickory1943903hickory
hiller94421633hiller_
hillers103718733hillers
hillo84721653hillo__
hilloa94713033hillo_a
hilloas104413553hilloas
hillock1646693hillock
hillocky2053403hillocky
hilloed113211293hilloed
hilloes103815963hilloes
hillos94618893hillo_s
hilly114422163hill__y
history1339423history
iller54821293_iller_
illusory1142183_illusory
illy76925333_ill__y
ivory1137373_i_vory
killer104917953killer_
killers114215583killers
killjoy2142343killjoy
killock1255253killock
lollopy12234773lollopy
lory75931713___lory
miliary1249463miliary
miller84625413miller_
millers93621343millers
milliary1346853milliary
millwork1745523millwork
milord999573mi_lord
paillard1146263paillard
pally105727123pall__y
palmary14338553palmary
paltry114910403p_altry
papillary1694403papillary
parlor8312673parlor_
parlors9312913parlors
pedlary13277543pedlary
pedlery13297073pedlery
pellitory1444153pellitory
peltry11288653p_eltry
philology1845293philology
phyllary1943233phyllary
picloram1445913picloram
piefort1249533piefort
piggery14266193piggery
pignora10306363pignora
pilar75221503pi_lar_
pileous9510523pileous
pilewort1389123pilewort
pilfer1139163pilfer_
pilfers1238963pilfers
piliform1555473piliform
pill65339463pill___
pillage103412603pillage
pillared11228093pillared
pillbox1843413pillbox
pilled94222753pill_ed
pilling103722563pilling
pillion92011703pillion
pillions101610923pillions
pilloried1265313pilloried
pillories1189573pillories
pillorying1642793pillorying
pillowed14156383pillowed
pills74130973pill__s
pilose84514243pi_lose
pilot77435063pi_lo_t
pilots84018873pi_lots
pilous84717753pi_lous
pilular938203pilular_
pily96132733pi_l__y
pinery115214293pi_nery
pinwork16107243pinwork
pinworm1467173pinworm
piscary1437423piscary
ploy96123603p__lo_y
pollard103511143pollard
poller83921853poller_
pollers93420023pollers
pollock1546843pollock
poultry1235383poultry
priory114110263p_riory
psaltry12213803psaltry
puller83820813puller_
pullers93618483pullers
pulley113713403pull_ey
pullout9310593pullout
pupillary16133143pupillary
pylori1147163p_ylori
raillery1134953raillery
riflery13345803riflery
sallowy13369343sallowy
signory11427523signory
siller64026063siller_
sillers73822103sillers
sillily10209783sillily
silly84527623sill__y
silvery13328093silvery
spiller92914333spiller_
spillers103311703spillers
spillway1642763spillway
tallowy13347633tallowy
tilbury1242983tilbury
tiller64222543tiller_
tillers73418743tillers
victory15326983victory
villose1038053villose
villous102810023villous
willer94021063willer_
willers103517913willers
willow12369693willo_w
willows13299753willows
willy115321913will__y
yellowy16255693yellowy

Search took 8 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.1401276364.3
2DLD Change Limit1340271547.09618887.7
3Display Results1541540.0602566.7
 (SQL Overall)1786911547.29624491.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.