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

76 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
comfortable209364(None) 
comfortably2392851comfortably
conformable2084982conformable
uncomfortable2262762uncomfortable
colorable1348243co_lor_able
committable1953493committable
commutable1845343com_mutable
comparable1845603compar_able
computable1855723com_putable
conferrable1845823conferrable
confirmable2064183confirmable
conformably2374113conformably
discomfortable2471523discomfortable
importable1646553_importable
uncomfortably2562183uncomfortably
affordable1942544_affordable
bootable12179224bo__o_table
cartable121314094c___artable
chartable1636834c__hartable
cogitable1446944co__gitable
collectable17104904collectable
colorably1646154co_lor_ably
colportage1552454colporta_ge
combinable1844724com_binable
combustible1952864combustible
comestible1645424com_estible
comfort143611694comfort____
comfortableness2482084comfortableness
comforted17315964comfort__ed
comforter16255984comfort__er
comforters17275194comfort_ers
comforting18165934comfort_ing
comfortingly2371874comfortingly
comfortless1851484comfortless
comforts15347324comfort___s
commandable2053294commandable
commendable2054344commendable
compactible2153654compactible
comparably2154394compar_ably
compassable1954214compassable
compatible18125574com_patible
compellable1953374compellable
compensable1955194compensable
compoundable2161584compoundable
condonable1545444condo_nable
confessable1854854confessable
confiscable2053674confiscable
conformal1696274conforma_l_
conformance20114474conformance
connectable1745714connectable
constable13311004co__nstable
construable1554784construable
contestable1546894contestable
conversable1846354conversable
convertible1846234convertible
cookable16147974co__o_kable
correctable1745234correctable
countable1348854co__untable
coverable1649104co_ver_able
covetable1648164co__vetable
deformable1844194_deformable
deportable1545654_deportable
exportable2144604_exportable
fordable1439594___fordable
forfeitable1962784forfeitable
formable1539504___formable
honorable1446954ho_nor_able
memorable1547534mem_or_able
performable2053134performable
portable12313204___portable
promotable1645034prom_o_table
reformable1745294_reformable
reportable1446954_reportable
sortable10312484___sortable
supportable1752694supportable
unconformable2263314unconformable

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.500357382.0
2DLD Change Limit148819768.86016796.7
3Display Results76760.0461652.2
 (SQL Overall)178691769.40618997.6
 
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.