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

201 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
collaged1227997(None) 
collage102813761collage_
collagen11338571collagen
collages113514241collages
collared113211141collared
collated113615061collated
cellared11398792cellared
collagens12256032collagens
collapsed1443222collapsed
collard103712922colla_rd
collaret103116702collaret
collate92919682collate_
collates103019142collates
college102410442college_
colleger11227932colleger
colleges112410522colleges
colleted113011662colleted
collided12309802collided
collied103316672coll_ied
collogued1344072collogued
colluded12296462colluded
foliaged1344672foliaged
hollaed11359852holla_ed
pillaged12298092pillaged
tallaged10257922tallaged
tollage82610162tollage_
tollages92410192tollages
ullaged937032_ullaged
allayed11138063_allayed
alleged9389323_alleged
bollard103210503bolla_rd
bolled94722653boll__ed
bollixed1834483bollixed
bolloxed1834473bolloxed
cabbaged1644383cabbaged
caged95426363c___aged
called94126733call__ed
callused1135853callused
cellae84915933cella_e_
cellarer10317923cellarer
cellaret103713573cellaret
celled94420323cell__ed
chelated142610483chelated
ciliated11510953ciliated
clagged12749233c_lagged
clanged114212653c_langed
clawed125115073c__lawed
clayed125013043c__layed
cleaned103512003c_leaned
cleared103612463c_leared
cleated103417843c_leated
cleaved134010483c_leaved
clinged113310093c_linged
cloaked14368543c_loaked
clogged12528653c_logged
coaled95022713co__aled
coalshed1435013coalshed
coated94927043co__ated
coaxed165612513co__axed
cockaded1836393cockaded
cogged116416613co__gged
coheaded1536603coheaded
coiled95123943coil__ed
coinage10310553coinage_
coinages11310803coinages
colead94114643colea__d
coleader1139183coleader
coled85540763co_l__ed
coleseed1147403coleseed
collaging1337913collaging
collagist1248013collagist
collapse1244273collapse
collapses1344683collapses
collar83816173colla__r
collards113310193collards
collarets11327333collarets
collars93816573colla_rs
collator10310373collator
colleague1243093colleague
colleagues1342933colleagues
collected1447973collected
colleen939543coll_een
collegers12256843collegers
collegia1146063collegia
collet84030363coll__et
collide103214793collide_
collider113410423collider
collides113214473collides
collie83621993coll_ie_
collier93618153coll_ier
collies94326583coll_ies
colligated1446273colligated
collimated1556083collimated
collocated1546163collocated
collogue1145473collogue
collogues1246213collogues
colloid10312883coll_oid
collude10337993collude_
colluder11276873colluder
colludes11279223colludes
colocated1439613colocated
cologned1237153cologned
colored10313473co_lored
coloured1148313coloured
columned1334923columned
comanaged1544523comanaged
combated1539823combated
compared153811823compared
concaved1636223concaved
conflated1539333conflated
congaed11399743conga_ed
cooled95224593cool__ed
copulated142710483copulated
cordage11310063cordage_
cordages12310113cordages
corelated12411823corelated
corkage1438373corkage_
corkages1539103corkages
corraded12128293corraded
corsage1039803corsage_
corsages11310363corsages
cottage104210573cottage_
cottager11306813cottager
cottages113310493cottages
cottagey14305233cottagey
courage10310993courage_
courages11311393courages
cowage12310673co_wage_
cowages13310943co_wages
cowhage1636303cowhage_
cowhages1736113cowhages
cowled125218393cowl__ed
culled94022473cull__ed
cullied104012353cull_ied
decollated14136283decollated
dolled83518073doll__ed
dollied93811143doll_ied
dolloped1234983dolloped
fellated1239563fellated
foliage1147533foliage_
foliages1247623foliages
foliated1249913foliated
followed15146273followed
foraged124812283fo_raged
holland11349473holla_nd
hollered1237603hollered
holloaed12157393holloaed
holloed113812753holl_oed
hollooed12146493hollooed
hollowed15157023hollowed
homaged1497413ho_maged
jollied15349273joll_ied
lolled74315823loll__ed
lolloped1134463lolloped
millage103112753millage_
millages113212903millages
montaged12107763montaged
moulage1037903moulage_
moulages1138053moulages
obliged1134983_obliged
ocellated1245453ocellated
pillage103412603pillage_
pillager11278553pillager
pillages113012613pillages
pillared11228093pillared
poleaxed1854823poleaxed
polkaed1435323polka_ed
pollard103511143polla_rd
pollarded1344703pollarded
polled94022003poll__ed
pollened1157783pollened
polluted1135433polluted
portaged12228463portaged
rolled74220243roll__ed
salvaged1335363salvaged
scolloped1443653scolloped
selvaged1334343selvaged
soilage8169353soilage_
soilages9189673soilages
solaced102911063so_laced
solated83618023so_lated
solvated12237443solvated
sullage859913sullage_
sullages939973sullages
tallage82712073tallage_
tallages92312003tallages
tillage83111343tillage_
tillages93011263tillages
tolled73819033toll__ed
ullage739043_ullage_
ullages838953_ullages
village113610833village_
villager12267513villager
villages123010603villages
volleyed1543533volleyed
volplaned1542733volplaned
voltage1136863voltage_
voltages1237253voltages
vorlage1136403vorlage_
vorlages1236033vorlages
voyaged1533513vo_yaged

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.406440125.6
2DLD Change Limit1461622017.00020880.3
3Display Results2012010.0762644.7
 (SQL Overall)1786912017.48223882.8
 
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.