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

94 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
regrettable145298(None) 
regrettably1752041regrettably
resettable1256512re_settable
erectable131210093_e_rectable
forgettable1752103forgettable
gettable11178133__g_ettable
rebuttable1443953re_buttable
registrable1452933registrable
remittable1445743re_mittable
repeatable1447603re_peatable
resectable1478123re_sectable
respectable1755043respectable
retractable1545123retractable
vegetable1545683veg_e_table
agreeable1244654_agre_eable
correctable1745234correctable
creatable1339564__creatable
deflectable1943804deflectable
degradable1543884degr_adable
delectable15247384de_lectable
deletable12149504de_le_table
depletable1544974deple_table
depreciable1854554depreciable
detectable15136604de_tectable
detestable13136504de_testable
ejectable20136574_e_jectable
electable13149624_e_lectable
expectable2345064_expectable
fermentable1844074fermentable
getable101712554__g_e_table
getatable1235954__g_etatable
grantable1257294__grantable
heritable1439454he_r_itable
negotiable1343974neg_otiable
nettable101610244___nettable
penetrable1446044pe_netrable
permutable1644984pe_rmutable
pettable121710714___pettable
presentable1546034pre_sentable
preventable1844984pre_ventable
receivable1745524re_ceivable
receptacle1653034re_ceptacle
redeemable1543954re_deemable
redoubtable1652124redoubtable
reefable1339534re__e_fable
reelable10311604re__e_lable
referable1439624re_fe_rable
refutable1477864re__futable
regenerable1453894regenerable
regental948954reg_enta_l_
registerable1552004registerable
regretful1352724regre_tful_
regretfully1872504regretfully
regretted1137234regrett__ed
regretter1045974regrett__er
regretters1144094regrett_ers
regretting1237784regrett_ing
regulable1246514reg__ulable
relatable11310054re__latable
releasable1245484re_leasable
relegable1258104re_le_gable
relievable1544664relie_vable
relocatable1542864relocatable
remediable1545134re_mediable
renderable1397164rende_rable
renewable1447444re_ne_wable
rentable101716334___rentable
repealable1445984re_pealable
repleviable1852664repleviable
reportable1446954re_portable
representable17102334representable
repressible1555104repressible
reputable1379124re__putable
resealable1246184re_sealable
reservable1546374re_servable
resettle837304re_sett__le
respectables1873034respectables
respectably2083854respectably
restable101618444___restable
restartable1343544restartable
retable91820404___re_table
retrainable1344354retrainable
retrievable1652554retrievable
revealable1545084re_vealable
reverable14310364re_ve_rable
revertible1575194re_vertible
reviewable1843434revie_wable
selectable14136444se_lectable
targetable1383874targe_table
treatable1139324__treatable
vegetables1642704veg_e_tables
vegetably1843954veg_e_tably
veritable1448744ve_r_itable
wettable13148044___wettable

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.436409841.7
2DLD Change Limit148819948.81316886.3
3Display Results94940.0462043.5
 (SQL Overall)178691949.29519224.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.