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

130 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
pillager1127855(None) 
pillage103412601pillage_
pillaged12298091pillaged
pillagers12276921pillagers
pillages113012611pillages
villager12267511villager
millage103112752millage_
millages113212902millages
pillar8314022pilla__r
pillared11228092pillared
spillage1146262spillage_
spillages1256082spillages
tillage83111342tillage_
tillages93011262tillages
village113610832village_
villagers13296152villagers
villagery16273362villagery
villages123010602villages
allayer10148213_allayer
alleger8319633_alleger
bilayer12347803bi_layer
biller84923483bill__er
billeter1037563billeter
cellarer10317923cellarer
collage102813763collage_
collaged12279973collaged
collagen11338573collagen
collages113514243collages
colleger11227933colleger
diallage1045233diallage_
diallages1145463diallages
dialoger1056083dialoger
dilater83515653di_later
fillagree1343623fillagree
filler94623623fill__er
giller74519733gill__er
grillage1055613grillage_
grillages1174943grillages
hiller94421633hill__er
hillier103413963hill_ier
iller54821293_ill__er
imager9108123_i_mager
inlayer1036933_inlayer
killdeer1362943killdeer
killer104917953kill__er
laager74312783__laager
lager65132863___lager
milage93414123mi_lage_
milages103114403mi_lages
mileage10299313mileage_
mileages11249693mileages
miller84625413mill__er
millier93716703mill_ier
milliner102811863milliner
mislayer1337503mislayer
oilpaper1242853oilpaper
packager17136153packager
pager84728203p___ager
palaver1238753p_alaver
pallier94417163pall_ier
pelage9515363p_elage_
pelages10714613p_elages
pellagra1143593pellagra
phalanger1554113phalanger
pilar75221503pi_la__r
pilaster1038163pilaster
pileate93815923pileate_
pileated112711133pileated
pilfer1139163pi_l_fer
pilferer1344923pilferer
pillaging1345553pillaging
pillars9313493pilla_rs
pilled94222753pill__ed
pillowed14156383pillowed
pilotage1145373pilotage_
pilotages1245503pilotages
pilsener1044753pilsener
pilsner935343pi_lsner
pilular938203pilula__r
pinger94324093pi__nger
pipage1199143pi_page_
pipages1289423pi_pages
pipeage1236203pipeage_
pipeages1336423pipeages
placer105117743p__lacer
plage84520403p__lage_
plages94520153p__lages
plaguer10328273p__laguer
planer84122653p__laner
plater84427693p__later
player115215213p__layer
pleader103511753p_leader
pleaser93912343p_leaser
pleater93916333p_leater
pledger11359173p_ledger
plugger11378433p_lugger
plunger104211243p_lunger
poller83921853poll__er
pollster1037103pollster
polltaker1542723polltaker
polluter1035403polluter
presager1138443presager
puller83820813pull__er
pullover13134643pullover
pupillage1442753pupillage_
pupillages1542373pupillages
salvager1235593salvager
silage72715303si_lage_
silages82514443si_lages
siller64026063sill__er
sillier74017593sill_ier
spiller92914333spill__er
spillover1442623spillover
sullage859913sullage_
sullages939973sullages
tallage82712073tallage_
tallaged10257923tallaged
tallages92312003tallages
tiller64222543till__er
tollage82610163tollage_
tollages92410193tollages
ullage739043_ullage_
ullaged937033_ullaged
ullages838953_ullages
villae95615383villa_e_
vintager12104823vintager
violater1137253violater
willer94021063will__er
willinger1343723willinger
willower14127453willower

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 Filter1786911461620.453394461.4
2DLD Change Limit1461621306.65621959.4
3Display Results1301300.0462826.1
 (SQL Overall)1786911307.15524974.3
 
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.