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

190 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
colleges11241052(None) 
collages113514241collages
college102410441college_
colleger11227931colleger
collegers12256841collegers
alleges84212572_alleges
callees94117782calle_es
collage102813762collage_
collaged12279972collaged
collagen11338572collagen
collagens12256032collagens
collates103019142collates
colleagues1342932colleagues
collects12279782collects
colleen939542colle_en
colleens1036842colleens
collegia1146062collegia
colleted113011662colleted
collets93517902colle_ts
collides113214472collides
collies94326582coll_ies
collogues1246212collogues
colludes11279222colludes
corteges1198822corteges
coulees9315512coule_es
pollees93215332polle_es
solfeges1244082solfeges
tollages92410192tollages
allees64521483_alle_es
allege74314653_allege_
alleged9389323_alleged
alleger8319633_alleger
allegers9378233_allegers
alleles73812033_alleles
boletes9316063bo_letes
bollixes1747203bollixes
bolloxes1736833bolloxes
bowlegs13366823bowleg_s
callee84327293calle_e_
callers94221963calle_rs
callets93821703calle_ts
calloses10313393calloses
calluses1039323calluses
cellules1036813cellules
challenges1643993challenges
clepes104214623c__lepes
coalers94419353coale_rs
coalesces1346043coalesces
coalless1038193coalle_ss
coatees93816553coate_es
cobles104622883cobl__es
coccyges1542333coccyges
cockeyes1967033cockeyes
coelomes1239293coelomes
coffees15329573coffe_es
coheres122917693co_heres
coilers93619903coile_rs
coinages11310803coinages
coleads102911423co_leads
coles76055063co_l__es
coleus86818273co_le_us
coleuses1039723coleuses
colies84837053co_l_ies
collagist1248013collagist
collapse1244273collapse
collapses1344683collapses
collards113310193collards
collared113211143collared
collaret103116703collaret
collarets11327333collarets
collars93816573coll_ars
collate92919683collate_
collated113615063collated
colleague1243093colleague
collect113314593colle_ct
collected1447973collected
collegial1245733collegial
collegian1245043collegian
collegians1344423collegians
collegium1444383collegium
collegiums1553323collegiums
collet84030363coll__et
collide103214793collide_
collided12309803collided
collider113410423collider
colliders12298073colliders
collie83621993coll_ie_
collied103316673coll_ied
collier93618153coll_ier
collieries1248333collieries
colliers103613583colliers
colligates1347713colligates
collins93419833coll_ins
collinses1138283collinses
collogue1145473collogue
collogued1344073collogued
colloids11310173colloids
collops112611753coll_ops
collude10337993collude_
colluded12296463colluded
colluder11276873colluder
colluders12285613colluders
colognes11310603colognes
cologs96517353co_log_s
colones96124433co_lones
colonies103620013colonies
colters93522443colte_rs
colugos1035693co_lugos
colures9315143co_lures
comperes143217973comperes
competes144117243competes
completes153212923completes
complexes22308103complexes
concedes13311063concedes
congees103517923conge_es
conges94928173co__nges
convenes132916913convenes
converges1538383converges
convexes20278273convexes
cooees85621893co_oe_es
coolers93522493coole_rs
coolies93824963cool_ies
cordages12310113cordages
corkages1539103corkages
corsages11310363corsages
cortege1098953cortege_
cortexes1797613cortexes
corvees124613793corve_es
cottages113310493cottages
coulee8323513coule_e_
courages11311393courages
cowages13310943co_wages
cowhages1736113cowhages
coxless1637743coxle_ss
culexes1636993c_ulexes
cullers93418853culle_rs
cullets94015613culle_ts
cullies94419963cull_ies
cullises103111313cullises
decolletes13123983decolletes
doglegs1034783dogleg_s
dollies83620983doll_ies
doolees83711613doole_es
foliages1247623foliages
folles93820473foll__es
follies103618943foll_ies
goldeyes1344483goldeyes
hollered1237603hollered
hollers103818233holle_rs
hollies103420813holl_ies
holloes103818193holl_oes
jollies143516273joll_ies
leges64427293___leges
lieges74113443__lieges
lollers72713793lolle_rs
lollies73116923loll_ies
mallees93315973malle_es
millages113212903millages
mollies93420233moll_ies
moulages1138053moulages
obliges1037143_obliges
pillages113012613pillages
pollee83623273polle_e_
pollened1157783pollened
pollens93713303polle_ns
pollers93420023polle_rs
pollices12410753pollices
pollutes1037613pollutes
polyenes13510063polyenes
rollers73117473rolle_rs
scoleces1237083sco_leces
soilages9189673soilages
solfege1144223solfege_
solleret8512223solleret
sollerets945263sollerets
sullages939973sullages
tallages92312003tallages
tillages93011263tillages
tollage82610163tollage_
tollers73217463tolle_rs
toluenes836763toluenes
ullages838953_ullages
villages123010603villages
volleyed1543533volleyed
volleyer1443163volleyer
volleyers1542773volleyers
volleys13316643volle_ys
voltages1237253voltages
vorlages1236033vorlages
walleyes1435603walleyes

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.436409841.7
2DLD Change Limit1461621906.76621602.4
3Display Results1901900.0762500.0
 (SQL Overall)1786911907.27824552.2
 
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.