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 “councils” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
councils124697(None) 
council1137461council_
bouncily1544382bouncily
codicils1346042codicils
councilor1343202councilor
councilors1443252councilors
counsels1037572counsels
counties10316272counties
bouncers12309353bouncers
bounces113813683bounc_es
bouncier1236033bouncier
bounciest1346433bounciest
bouncing13318773bouncing
bounties10311393bounties
cancels114113313c_ancels
chancels15439083chancels
chancily1845243chancily
chunkily2043083chunkily
chunnels13304553chunnels
coccids11277213co_ccids
codicil1246803codicil_
cogencies1448103cogencies
coils75030083co___ils
coincide1346493coincide
coincides1446423coincides
colicins12312853colicins
conceals123111013co_nceals
conceits122813613co_nceits
conchas144013313co_nchas
conches144019813co_nches
conchies153214853co_nchies
conchos144313953co_nchos
conchs134714903co_nc_hs
concise11314473co_ncise
concurs11311453co_ncurs
concuss1138063co_ncuss
confits122811423co_nfits
congius103210073co_ngius
conics103920593co_n_ics
conies84338593co_n_ies
conins84327233co_n_ins
conoids10813883co_noids
consols92914073co_nsols
consuls92412313co_nsuls
cooncans1246273cooncans
coonties10513793coonties
corbeils12358073corbeils
corncobs1444723corncobs
corncribs1542963corncribs
cornels94716663corn_els
cornices12713283cornices
cornicle1258783cornicle
cornicles1368243cornicles
cornily12410853corn_ily
couches144020463cou_ches
coulis84018753cou_li_s
couloirs1045983couloirs
councillor1452953councillor
councillors1552703councillors
councilman1652243councilman
councilmen1652613councilmen
counsel948543counsel_
counters103320183counters
countess103710043countess
countian1048123countian
countians1147323countians
counting113115263counting
countries11313593countries
counts84618273coun__ts
couscous1246663couscous
cousins9516003cou_sins
crunches153711353crunches
crunchily1943193crunchily
domicils1345073domicils
hobnails1343303hobnails
jounces16369853jounc_es
jouncier1734423jouncier
jounciest1844613jounciest
jouncing18336853jouncing
nuncios937113_nuncios
ounces83617773_ounc_es
pencils113011763_pencils
pontils9312213po_ntils
pouncers12349203pouncers
pounces114113893pounc_es
pouncing13318883pouncing
poundals1145013poundals
roundels9217743roundels
stencils1046403stencils
toenails847213toenails
tonsils7310183to_nsils
uncials92510523__uncials
uncoils979533__uncoils

Search took 10 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.360496363.9
2DLD Change Limit146162939.17315933.9
3Display Results93930.0303100.0
 (SQL Overall)178691939.56318685.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.