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

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

48 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
collectedly198300(None) 
collected1447962collected__
connectedly1953212connectedly
collectable17104893collectable
collectible17104483collectible
collectively22114623collectively
colleted113011653colle_ted__
conceitedly1953783conceitedly
concertedly1954773concertedly
contentedly1754903contentedly
affectedly2252154_affectedly
allegedly1472694_alle_gedly
cockeyedly2551544cocke_yedly
coerected1447644coerected__
coldheartedly2382024coldheartedly
colectomy1854874co_lect_omy
collated113615064coll_ated__
collect113314594collect____
collectables18103354collectables
collectanea1552794collectanea
collectedness1863704collectedness
collectibles1883604collectibles
collecting1548284collect_ing
collection1448204collect_ion
collections1547914collections
collective1747124collect_ive
collectives1846034collectives
collectivity2254234collectivity
collector1346394collect__or
collectors1446594collect_ors
collects12279784collect___s
collegially1753404collegially
collegiately18101714collegiate_ly
collocated1546164collocated__
complected19295864complected__
completely1944534comple_te_ly
complicatedly2561704complicatedly
concededly1952804conce_dedly
confected1739074confected__
confessedly2052154confessedly
connected1438754connected__
convected1738784convected__
corrected1438114corrected__
correctly1644964correct__ly
dejectedly2452384_dejectedly
expectedly2572514_expectedly
recollected1643854recollected__
uncollected1653674uncollected__

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 Filter1786911488190.1601116818.8
2DLD Change Limit148819488.32617874.0
3Display Results48480.0331454.5
 (SQL Overall)178691488.51920975.6
 
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.