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

230 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
colleen93953(None) 
colleens1036841colleens
callee84327292callee_
callees94117782callees
collagen11338562collagen
collect113314592collect
college102410432college
colleger11227922colleger
colleges112410512colleges
collet84030362coll_et
colleted113011652colleted
collets93517902collets
collie83621992collie_
collied103316672collied
collier93618152collier
collies94326582collies
coulee8323502coulee_
coulees9315502coulees
pollee83623272pollee_
pollees93215332pollees
pollen83416452poll_en
tollmen935732tollmen
allee54932123_allee_
allees64521483_allees
baleen8613053_baleen
belleek1347243belleek
bellmen1138143bellmen
bolled94722653boll_ed
boreen8314313bo_reen
bullpen1135193bullpen
callan83619603call_an
called94126733call_ed
caller85125483call_er
callers94221963callers
callet84536763call_et
callets93821703callets
canteen9411083canteen
careen84119493c_areen
cellae84915933cellae_
celled94420323cell_ed
clean75420413c__lean
cleek115514913c__leek
cloven114211513c_loven
coalbin1137533coalbin
coaled95022703coal_ed
coaler84121713coal_er
coalers94419353coalers
coalier93416183coalier
coalless1038193coalless
coarsen93210323coarsen
coatee84327223coatee_
coatees93816553coatees
coble94823173cobl_e_
cobles104622883cobl_es
codein94916723co_dein
coden86128543co__den
codlin94516443codl_in
coffee144113743coffee_
coffees15329573coffees
coiled95123933coil_ed
coiler84421593coil_er
coilers93619903coilers
colder95121843co_lder
coldest102514763coldest
cole66956113co_l_e_
colead94114643co_lead
coled85540753co_l_ed
coles76055063co_l_es
coleseed1147393coleseed
coleus86818273co_leus
colicin11313743colicin
colies84837053co_lies
colin76231693co_l_in
collage102813753collage
collaged12279963collaged
collagens12256033collagens
collages113514233collages
collar83816173coll_ar
collard103712923collard
collared113211143collared
collaret103116703collaret
collars93816573collars
collate92919683collate
collated113615063collated
collates103019143collates
collected1447963collected
collects12279783collects
collegers12256833collegers
collegia1146053collegia
collegian1245043collegian
colleting12311053colleting
collide103214783collide
collided12309793collided
collider113410413collider
collides113214463collides
colliers103613583colliers
colliery13307363colliery
collins93419833collins
colloid10312883colloid
collop107312313coll_op
collops112611753collops
collude10337983collude
colluded12296453colluded
colluder11276863colluder
colludes11279213colludes
colly104926773coll__y
collying14319543collying
cologne1039353cologne
colon78630193co_l_on
colone85425003colone_
colonel94213283colonel
colones96124433colones
colored10313473colored
colorer9312523colorer
colormen1247243colormen
colter84625093co_lter
colters93522443colters
columel1136273columel
column1038103co_lumn
colure8314163colure_
colures9315143colures
compeer133811553compeer
concern113011963concern
condemn1237113condemn
congee96024463congee_
congeed113212313congeed
congees103517923congees
contemn1137803contemn
convene123314323convene
cooee74531023co_oee_
cooeed95917863co_oeed
cooees85621893co_oees
cooled95224583cool_ed
cooler84824713cool_er
coolers93522493coolers
coolest9318643coolest
coolie83821603coolie_
coolies93824963coolies
copen94826433co__pen
corvee114320093corvee_
corvees124613793corvees
coulter94115603coulter
coven106925043co__ven
cowled125218383cowl_ed
cowmen13810923co_wmen
coxless1637743coxless
cozen165019703co__zen
culled94022473cull_ed
culler84322253cull_er
cullers93418853cullers
cullet84727313cull_et
cullets94015613cullets
cullied104012353cullied
cullies94419963cullies
cullion91910233cullion
dolled83518073doll_ed
dollied93811143dollied
dollies83620983dollies
dolmen93911373do_lmen
doolee73018953doolee_
doolees83711613doolees
fallen93813373fall_en
folles93820473foll_es
follies103618943follies
gallein8299043gallein
galleon8278713galleon
golden84411153go_lden
gombeen1243733gombeen
holden104113953ho_lden
hollaed11359853hollaed
holler93520613holl_er
hollered1237603hollered
hollers103818233hollers
hollies103420813hollies
holloed113812753holloed
holloes103818193holloes
holpen11299413ho_lpen
jollied15349273jollied
jollier142911003jollier
jollies143516273jollies
lolled74315823loll_ed
loller63315283loll_er
lollers72713793lollers
lollies73116923lollies
mallee84525593mallee_
mallees93315973mallees
mollie83517103mollie_
mollies93420233mollies
molten83311813mo_lten
moreen8313343mo_reen
mullein9278563mullein
mullen83714763mull_en
noblemen1245033noblemen
oilmen848313_oilmen
olden65114853_o_lden
olein5316003_o_lein
poleyn1157323po_leyn
polled94022003poll_ed
pollened1157773pollened
pollens93713303pollens
poller83921853poll_er
pollers93420023pollers
pollex153711163poll_ex
polyene1259363polyene
posteen93512623posteen
poteen83514263po_teen
potheen12257893potheen
potteen9319673potteen
rolled74220243roll_ed
roller63919793roll_er
rollers73117473rollers
solemn838643so_lemn
solleret8512223solleret
spleen8310263_spleen
stollen747583stoll_en
sullen62914293sull_en
swollen1034263swoll_en
tolled73819033toll_ed
toller63819443toll_er
tollers73217463tollers
tollman935863tollman
toluene736463toluene
villein1036753villein
volley12419743voll_ey
volleyed1543533volleyed
volleyer1443163volleyer
volleys13316643volleys
woolen93111373wool_en
woollen1034723woollen
woolmen1234973woolmen

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272306.70319995.1
3Display Results2302300.0763026.3
 (SQL Overall)1786912306.93525766.5
 
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.