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

150 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
colleens103684(None) 
colleen939531colleen_
callees94117782callee_s
collagens12256032collagens
collects12279782collects
collegers12256832collegers
colleges112410512colleges
collets93517902coll_ets
colliers103613582colliers
collies94326582collie_s
collins93419832coll_ins
coulees9315502coulee_s
pollees93215332pollee_s
pollens93713302poll_ens
allees64521483_allee_s
baleens938473_baleens
belleeks1444363belleeks
boreens9310403bo_reens
bullpens1254083bullpens
callans94518473call_ans
callee84327293callee__
callers94221963call_ers
callets93821703call_ets
canteens1038573canteens
careens94514703c_areens
cleans85817053c__leans
cleeks125010543c__leeks
coalbins1237083coalbins
coalers94419353coal_ers
coalless1038193coalless
coarsens10348123coarsens
coatees93816553coatee_s
cobles104622883cobl_e_s
codeins103715483co_deins
codeless112010113codeless
codens94821013co__dens
codlins104116243codl_ins
coffees15329573coffee_s
coilers93619903coil_ers
coldness1137953coldness
coleads102911423co_leads
coles76055063co_l_e_s
coleseeds1244323coleseeds
coleus86818273co_l_eus
colicins12312853colicins
colies84837053co_lie_s
colins85229043co_l_ins
collagen11338563collagen_
collages113514233collages
collards113310193collards
collarets11327333collarets
collars93816573coll_ars
collates103019143collates
collect113314593coll_ect
college102410433coll_ege
colleger11227923colleger
collegia1146053collegia
collegians1344423collegians
collet84030363coll_e_t
colleted113011653colleted
colleting12311053colleting
colliders12298073colliders
collides113214463collides
collie83621993collie__
collied103316673collie_d
collier93618153collie_r
colliery13307363colliery
colloids11310173colloids
collops112611753coll_ops
colluders12285613colluders
colludes11279213colludes
collying14319543collying
colognes11310603colognes
colonels104210453colonels
colones96124433colone_s
colons86028683co_l_ons
coloreds1138093coloreds
colorers10312183colorers
colters93522443co_lters
columels1244813columels
columns1136473co_lumns
colures9315143colure_s
compeers143410013compeers
concerns122710833concerns
condemns1336293condemns
congees103517923congee_s
contemns1237403contemns
convenes132916913convenes
cooees85621893co_oee_s
coolers93522493cool_ers
coolies93824963coolie_s
coolness1037743coolness
copens106119963co__pens
coreless103013833coreless
corvees124613793corvee_s
coulee8323503coulee__
coulters103614313coulters
covens114919263co__vens
coxless1637743coxl_ess
cozens176314923co__zens
cullers93418853cull_ers
cullets94015613cull_ets
cullies94419963cullie_s
cullions10219223cullions
dollies83620983dollie_s
dolmens10388693do_lmens
doolees83711613doolee_s
folles93820473foll_e_s
follies103618943follie_s
galleins9258693galleins
galleons9258443galleons
gombeens1342703gombeens
holeless1189363holeless
hollers103818233holl_ers
hollies103420813hollie_s
holloes103818193holloe_s
jolliers15357433jolliers
jollies143516273jollie_s
lollers72713793loll_ers
lollies73116923lollie_s
mallees93315973mallee_s
mollies93420233mollie_s
moreens939963mo_reens
mulleins10277053mulleins
mullens93611313mull_ens
oleins6313523_o_leins
poleless1089873poleless
poleyns1236113po_leyns
pollee83623273pollee__
pollen83416453poll_en_
pollened1157773pollened
pollers93420023poll_ers
polyenes13510063polyenes
posteens10309733posteens
poteens92910883po_teens
potheens13266483potheens
potteens10256793potteens
rollers73117473roll_ers
soleless8910033soleless
sollerets945263sollerets
spleens937103_spleens
stollens835293stoll_ens
tollers73217463toll_ers
tollmen935733tollmen_
toluenes836763toluenes
villeins1136043villeins
volleyers1542773volleyers
volleys13316643voll_eys
woolens10398843wool_ens
woollens1144093woollens

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.1561145455.1
2DLD Change Limit1461621507.87318565.0
3Display Results1501500.0632381.0
 (SQL Overall)1786911508.09222082.4
 
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.