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

173 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
villages12301060(None) 
millages113212901millages
pillages113012611pillages
tillages93011261tillages
village113610831village_
villager12267511villager
villagers13296151villagers
collages113514242collages
diallages1145462diallages
grillages1174942grillages
milages103114402mi_lages
mileages11249692mileages
millage103112752millage_
pillage103412602pillage_
pillaged12298092pillaged
pillager11278552pillager
pillagers12276922pillagers
silages82514442si_lages
spillages1256082spillages
sullages939972sullages
tallages92312002tallages
tillage83111342tillage_
tollages92410192tollages
ullages838952_ullages
villae95615382villa_e_
villagery16273362villagery
villains1138012villains
villas96117262villa__s
villenages1442952villenages
vintages12118272vintages
violates11311192violates
visages1138692vi_sages
voltages1237252voltages
vorlages1236032vorlages
alleges84212573_alleges
anlages82414113_anlages
ballades114211643ballades
bilges94915633bi_l_ges
billies93923503bill_ies
biplanes1238573biplanes
bulkages1535273bulkages
bullaces12299433bullaces
ciliates10413453ciliates
collage102813763collage_
collaged12279973collaged
collagen11338583collagen
collagens12256043collagens
collates103019143collates
colleges112410523colleges
diallage1045233diallage_
dilates83220663di_lates
dillies84122163dill_ies
fellates11312753fellates
filiates11412663filiates
fillagree1343623fillagree
fillagrees1452583fillagrees
filles94224523fill__es
fillies103420253fill_ies
foliages1247623foliages
gallates92815533gallates
gillies84120963gill_ies
grillades1194543grillades
grillage1055613grillage_
haulages1236623haulages
haylages1536013haylages
hilloes103815963hill_oes
illites72415013_illites
illudes8347553_illudes
illumes9327673_illumes
images91411463_i_mages
incages103013883_incages
inlaces92512903_inlaces
innages82911303_innages
keelages1335743keelages
killdees1373963killdees
killies113318113kill_ies
linages8813173li_nages
lineages979183lineages
linkages1385953linkages
meltages1148243meltages
milage93414123mi_lage_
mileage10299313mileage_
millcakes1744683millcakes
milles84526563mill__es
milliares1149403milliares
millimes122411373millimes
millines102718063millines
millraces1345753millraces
mintages111110513mintages
mirages102213533mi_rages
mispages13311183mispages
moulages1138053moulages
oeillades1043953oeillades
pelages10714613_pelages
pillared11228093pillared
pillars9313493pilla_rs
pilotages1245503pilotages
pipages1289423pi_pages
pipeages1336423pipeages
plages94520153__plages
pupillages1542373pupillages
rilles64725503rill__es
rivages1138873ri_vages
salvages1238123salvages
scalages113010253scalages
selvages1236513selvages
signages1037483signages
silage72715303si_lage_
silanes72517163si_lanes
sillies73425083sill_ies
sinkages1386853sinkages
smallages1245293smallages
soilages9189673soilages
spillage1146263spillage_
sullage859913sullage_
tallage82712073tallage_
tallaged10257923tallaged
thirlages1343763thirlages
tillites8312833tillites
tollage82610163tollage_
treillages1143463treillages
ullage739043_ullage_
ullaged937033_ullaged
vacillates1555723vacillates
vallate103016563vallate_
valuates112811203valuates
vantages12119023vantages
ventages12119773ventages
vibrates132210613vibrates
vicarages1574433vicarages
vicinages1544073vicinages
vilayet1348533vi_layet
vilayets1443073vi_layets
vilifies1439593vilifies
villa85321233villa___
villadom1442513villadom
villadoms1542343villadoms
villageries1552763villageries
villain1038483villa_in
villainess1343853villainess
villainies1344123villainies
villainy1444883villainy
villatic1346233villatic
villeins1136043villeins
villenage1342633villenage_
villose1038053villose_
villous102810023vill_ous
vills86429323vill___s
villus93611223vill__us
vintage11128143vintage_
vintager12104823vintager
vintagers13123903vintagers
violas93713523viola__s
violate10311553violate_
violated1237883violated
violater1137253violater
violaters1245963violaters
violones1137383violones
viragoes1245233vi_ragoes
viragos1146713vi_ragos
virgates1237923virgates
visage1049083vi_sage_
visaged1235683vi_saged
vitiates112311433vitiates
vivaces1536413vi_vaces
volplanes1444673volplanes
voltage1136863voltage_
vorlage1136403vorlage_
voyages1435703v_oyages
vulgates12237233vulgates
willies103920153will_ies
windages1338263windages
zillahs1935383zilla_hs

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 Filter1786911461620.440406115.9
2DLD Change Limit1461621737.51319454.5
3Display Results1731730.0802162.5
 (SQL Overall)1786911738.03322244.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.