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

112 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
council113747(None) 
councils1246971councils
bouncily1544382bouncily
codicil1246812codicil
councilor1343202councilor
counsel948542counsel
bounce104014833bounc_e
bounced123610553bounced
bouncer113811333bouncer
bounces113813683bounces
bouncier1236033bouncier
bouncing13318773bouncing
bouncy13409073bounc_y
cancel105316683c_ancel
chancel144011773chancel
chancily1845243chancily
chunkily2043083chunkily
chunnel12395303chunnel
coccal9310223co_ccal
cocci82812673co_cci_
coccic8298943co_ccic
coccid102910743co_ccid
codicils1346043codicils
coil66439653co___il
coincide1346493coincide
colicin11313743colicin
comical13312223comical
conceal113313013co_nceal
conceit113218073co_nceit
conch124620073co_nc_h
concha134213283co_ncha
conchal144211583co_nchal
conchie143312683co_nchie
concho134414263co_ncho
conchs134714903co_nchs
conchy163710223co_nchy
concise11314473co_ncise
concur10411103co_ncur
confit113316403co_nfit
congii957363co_ngii
coni65534803co_n_i_
conic95329793co_n_ic
conical11316203conical
conics103920593co_nics
conin76232723co_n_in
conoid9818883co_noid
consol82614113co_nsol
consul82312303co_nsul
cooncan1147233cooncan
coontie9311423coontie
corbeil11859213corbeil
corncob1345663corncob
corncrib1443903corncrib
corneal94414503corneal
cornel84020053corn_el
cornice11612933cornice
cornicle1258783cornicle
cornily12410853corn_ily
cornual94210173cornual
couch125320113cou_c_h
coulis84018763cou_lis
couloir936153couloir
councillor1452953councillor
councilman1652243councilman
councilmen1652613councilmen
councilors1443253councilors
counsels1037573counsels
count74932053coun__t
counted103815803counted
counter94220153counter
countian1048123countian
counties10316283counties
counting113115273counting
country12388043country
counts84618273coun_ts
county114313323coun_ty
cousin8517163cou_sin
couthie121810553couthie
crucial1157893cru_cial
crunch13349503crunc_h
crunchily1943193crunchily
crunchy17324763crunchy
cuneal8611513c_uneal
domicil1246433domicil
hobnail1243973hobnail
jounce153310733jounc_e
jounced17337613jounced
jounces16369853jounces
jouncier1734423jouncier
jouncing18336853jouncing
jouncy18336203jounc_y
nounal639813noun_al
nuncio837973_nuncio
ounce77019933_ounc_e
ounces83617773_ounces
pencil103712973_pencil
pontil8315463po_ntil
pounce105214093pounc_e
pounced123510623pounced
pouncer113511233pouncer
pounces114113893pounces
pouncing13318883pouncing
poundal1036403poundal
roundel8308853roundel
stencil946893stencil
toenail738783toenail
tonsil6311873to_nsil
unci65019463__unci_
uncia75015163__uncia
uncial83715223__uncial
uncoil8811853__uncoil
until53517743__until

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271126.62620227.4
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.07825246.0
 
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.