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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

80 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
villagers1329615(None) 
pillagers12276921pillagers
villager12267511villager_
villagery16273361villagery
villages123010601village_s
millages113212902millage_s
pillager11278552pillager_
pillages113012612pillage_s
tillages93011262tillage_s
village113610832village__
villageries1552762villageries
vintagers13123902vintagers
violaters1245962violaters
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
pillage103412603pillage__
pillaged12298093pillage_d
pillars9313493pilla__rs
salvagers1344693salvagers
silages82514443si_lage_s
sillers73822103sill__ers
spillages1256083spillage_s
sullages939973sullage_s
tallages92312003tallage_s
tillage83111343tillage__
tillers73418743till__ers
tollages92410193tollage_s
ullages838953_ullage_s
veligers1237023v_eligers
vilayets1443073vi_layets
vilifiers1544563vilifiers
villadoms1542343villadoms
villae95615383villa_e__
villainess1343853villainess
villains1138013villa_ins
villas96117263villa___s
villenages1442953villenage_s
vintager12104823vintager_
vintages12118273vintage_s
violater1137253violater_
violates11311193violate_s
violators1246583violators
visages1138693vi_sage_s
vitamers1334683vi_tamers
volleyers1542773volleyers
voltages1237253voltage_s
vorlages1236033vorlage_s
voyagers1532813v_oyagers
willers103517913will__ers
willowers15166693willowers

Search took 9 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.466383457.1
2DLD Change Limit148641807.50319810.9
3Display Results80800.0302666.7
 (SQL Overall)178691807.99922339.2
 
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.