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

44 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
comfortably239285(None) 
comfortable2093631comfortable
conformably2374112conformably
uncomfortably2562172uncomfortably
colorably1646153co_lor_ably
comfortingly2371873comfortingly
comparably2154393compar_ably
conformable2084983conformable
uncomfortable2262753uncomfortable
affordably2251834_affordably
colorable1348244co_lor_able
combustibly2252364combustibly
comfort143611694comfort____
comforted17315964comfort__ed
comforter16255984comfort__er
comforters17275194comfort_ers
comforting18165934comfort_ing
comfortless1851484comfortless
comforts15347324comfort___s
commendably2353664commendably
committable1953484committable
commutable1845334com_mutable
comparable1845604compar_able
compatibly21134874com_patibly
computable1855714com_putable
conferrable1845824conferrable
confirmable2064184confirmable
confocally2044344confo_cally
conformal1696274conforma_l_
convertibly2155114convertibly
corporally1775294corpor_ally
corporately1854124corporately
corporeally1863224corporeally
countably1646284co__untably
discomfortable2471514discomfortable
formably1846664___formably
honorably1745164ho_nor_ably
immortally1753844_immortally
importable1646554_importable
memorably1845624mem_or_ably
mortally1339934__m_ortally
portably1539314___portably
sortably1338804___sortably
unconformably2562714unconformably

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 Filter1786911488190.1561145455.1
2DLD Change Limit148819449.28316031.3
3Display Results44440.0301466.7
 (SQL Overall)178691449.46918871.2
 
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.