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

103 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
pillagers1227692(None) 
pillager11278551pillager_
pillages113012611pillage_s
villagers13296151villagers
millages113212902millage_s
pillage103412602pillage__
pillaged12298092pillage_d
pillars9313492pilla__rs
spillages1256082spillage_s
tillages93011262tillage_s
villager12267512villager_
villagery16273362villagery
villages123010602village_s
allayers11156633_allayers
allegers9378233_allegers
bilayers13296923bi_layers
billers94720833bill__ers
billeters1136873billeters
cellarers11236503cellarers
collagens12256043collagens
collages113514243collage_s
collegers12256843collegers
diallages1145463diallage_s
dialogers1155163dialogers
dilaters92513063di_laters
fillagree1343633fillagree
fillagrees1452583fillagrees
fillers104320213fill__ers
gillers84216903gill__ers
grillages1174943grillage_s
hillers103718733hill__ers
imagers10107763_i_magers
inlayers1135643_inlayers
killdeers1462453killdeers
killers114215583kill__ers
laagers83411253__laagers
lagers74826143___lagers
milages103114403mi_lage_s
mileages11249693mileage_s
millage103112753millage__
millers93621343mill__ers
milliers102611903mill_iers
milliners11289953milliners
mislayers1445943mislayers
oilpapers1342833oilpapers
packagers18144683packagers
pagers94423253p___agers
palavers1337993p_alavers
pelages10714613p_elage_s
pellagra1143593pellag_ra
pellagras1243383pellagras
phalangers1673763phalangers
pilasters1138223pilasters
pilferers1444583pilferers
pilfers1238963pi_l_fers
pillaging1345573pillaging
pillar8314023pilla__r_
pillared11228093pillare_d
pillarless1242543pillarless
pilotages1245503pilotage_s
pilseners1144953pilseners
pilsners1035533pi_lsners
pingers104020743pi__ngers
pipages1289423pi_page_s
pipeages1336423pipeage_s
placers114515263p__lacers
plages94520153p__lage_s
plaguers11286503p__laguers
planers94517943p__laners
platers93924093p__laters
players124313763p__layers
pleaders113210183p_leaders
pleasers104010293p_leasers
pleaters103613793p_leaters
pledgers12387643p_ledgers
pluggers12297023p_luggers
plungers11379403p_lungers
pollers93420023poll__ers
pollsters1137173pollsters
polltakers1642403polltakers
polluters1135033polluters
presagers1236943presagers
pullers93618483pull__ers
pullovers14124243pullovers
pupillages1542373pupillage_s
salvagers1344693salvagers
silages82514443si_lage_s
sillers73822103sill__ers
spillage1146263spillage__
spillers103311703spill__ers
spillovers1542403spillovers
sullages939973sullage_s
tallages92312003tallage_s
tillage83111343tillage__
tillers73418743till__ers
tollages92410193tollage_s
ullages838953_ullage_s
village113610833village__
villageries1552763villageries
vintagers13123903vintagers
violaters1245963violaters
willers103517913will__ers
willowers15166693willowers

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411036.89021573.4
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.35924282.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.