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

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

81 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
representable1710233(None) 
presentable1546032__presentable
presentably1855283__presentably
preventable1844983__preventable
reprehensible2062083reprehensible
representative19192313representative
fermentable1844074fe_r_mentable
preservable1844164__preservable
preventible1854424__preventible
regrettable1452984regr__ettable
repeatable1447604rep___eatable
reprehensibly2361944reprehensibly
represent11410074represent____
representation16154124representation
representatives20211894representatives
represented1444114represent__ed
representer1353614represent__er
representers1452774represent_ers
representing1555134represent_ing
represents1246754represent___s
repressible1555104repres__sible
resectable1478124___resectable
resettable1256514___resettable
apprehensible22131845apprehensible
decremental1654675decrementa_l_
dependable1645795dep___endable
depletable1544975dep__le_table
depreciable1854555depr__eciable
depressible1654595depres__sible
detestable13136505de_tes__table
disrespectable2161365disrespectable
erectable131210095_e_r__ectable
foreseeable1652745_forese_eable
impregnable1853485impre_gn_able
merchantable2152025me_rchantable
patentable1444935__p_atentable
personable1467075pe_r_son_able
predictable1844995__predictable
preferable1746725__prefe_rable
pregnable1456695__pre_gn_able
presentative1755345__presentative
presentee11411865__present__ee
presentence1546395__presentence
presently1449065__present__ly
presettle1145945__prese_t_tle
presumable1645205__pres_umable
printable1338205__pr__intable
projectable2452905__projectable
prosecutable1851795__prosecutable
reasonable1246285re__ason_able
recommendable2271935recommendable
redeemable1543955re_de_e_mable
regenerable1453885re_gene_rable
regrettably1752045regr__ettably
rentable101716335___r__entable
reorientate1153375reor_ienta_te
repealable1445985rep___ealable
repentance1456625rep___entance
replaceable1743225replace__able
replenishable2061105replenishable
repleviable1852665rep__leviable
reportable1446955rep___ortable
reprehensive20122835reprehen_sive
representations17153895representations
reproachable2152615repr_oachable
reputable1379125rep____utable
resealable1246185___resealable
reservable1546365___reservable
respectable1755045re__spectable
restable101618445___res__table
retractable1545125retr__actable
retrainable1344355retr_ain_able
retrievable1652555retr_ie_vable
screenable1443705_scre_en_able
sedimentable1752965se_dimentable
supersensible1762495supersensible
unpatentable1653685unp_atentable
unpredictable2052955unpredictable
unprintable1555215unpr__intable
unrepeatable1654535_unrepeatable
unrespectable1953525_unrespectable

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 Filter1786911247900.390458182.1
2DLD Change Limit124790819.47013177.4
3Display Results81810.0461760.9
 (SQL Overall)178691819.90618038.7
 
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.