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

176 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
tillages9301126(None) 
millages113212901millages
pillages113012611pillages
tallages92312001tallages
tillage83111341tillage_
tollages92410191tollages
villages123010601villages
collages113514242collages
diallages1145462diallages
grillages1174942grillages
milages103114402mi_lages
mileages11249692mileages
millage103112752millage_
pillage103412602pillage_
pillaged12298092pillaged
pillager11278552pillager
pillagers12276922pillagers
silages82514442si_lages
spillages1256082spillages
sullages939972sullages
tallage82712072tallage_
tallaged10257922tallaged
thirlages1343762thirlages
tillites8312832tillites
tollage82610162tollage_
treillages1143462treillages
ullages838952_ullages
village113610832village_
villager12267512villager
villagers13296152villagers
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
etiolates949213etiolates
fellates11312753fellates
filiates11412663filiates
fillagree1343633fillagree
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
keelages1335753keelages
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_
stealages1046043stealages
sullage859913sullage_
tailgates1046533tailgates
taillamps1342613taillamps
tailles72516473taill__es
tailplanes1244313tailplanes
tailraces1144903tailraces
tallies73624603tall_ies
tallises82713263tallises
tankages13217113tankages
tannages9228963tannages
tellies73820503tell_ies
telltales944393telltales
tentages91011043tentages
thanages12107623thanages
thenages12107483thenages
thirlage1243823thirlage_
tilaks1097353ti_la_ks
tildes74513963ti_l_des
tiles55542103ti_l__es
tilings84212793tiling_s
tillable10159753tillable
tilled74722953till__ed
tiller64222543till__er
tillered937443tillered
tillers73418743till_ers
tillite7313563tillite_
tills54631713till___s
timbales12227843timbales
tinges74722343ti__nges
tinplates1147773tinplates
tinwares1137913tinwares
tirades8311723ti_rades
tisanes7311853ti_sanes
titillates1045133titillates
titlarks1243693titlarks
titles63719923titl__es
titrates82314663titrates
tolanes74216313t_olanes
tollgates1046053tollgates
toluates8138903toluates
tonnages9187873tonnages
towages1139233t_owages
treillage1043673treillage_
triages82613793t_riages
triplanes1148803triplanes
tuilles72411923tuill__es
tulles63218893tull__es
tunnages9195903tunnages
tutelages1044013tutelages
ullage739043_ullage_
ullaged937033_ullaged
villae95615383villa_e_
villagery16273363villagery
villains1138013villains
villas96117263villa__s
villenages1442953villenages
vintages12118273vintages
violates11311193violates
visages1138693vi_sages
voltages1237253voltages
vorlages1236033vorlages
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.420425454.8
2DLD Change Limit1461621768.08018089.4
3Display Results1761760.0602933.3
 (SQL Overall)1786911768.56020875.1
 
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.