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

84 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
returnables135212(None) 
returnable1244791returnable_
burnables1344003__burnables
nonreturnables16101503nonreturnables
retables101712673ret___ables
returnees9396113return__ees
reusables1175223re_u_sables
turnable1037853__turnable_
turntables1242263__turntables
unreturnable1453643unreturnable_
burnable1237264__burnable_
deferrables1752284deferrables
desirables1344214desir_ables
deterrable1345724deterrable_
detonable1247624det_onable_
durables11237014__dur_ables
educables1443474_edu_cables
enables92813124_e___nables
eternals8238954_eterna_l_s
incunables1494024incu_nables
incurables14105144incur_ables
learnable1145564le_arnable_
nonreturnable15102484nonreturnable_
perturbable1752234perturbable_
petrales10312984pet_r_a_les
ratables10159724rat___ables
rationales1049314rationa_les
reasonable1246284reasonable_
reburials1143934reburia_l_s
rebuttable1443954rebuttable_
receivables1852464receivables
recordable1545554recordable_
recyclables2051864recyclables
referable1439624refer_able_
refinable1438624re_finable_
reformable1745294reformable_
refundable1643804refundable_
refurnishes17102994refurnishes
refusable1476684refu_sable_
refutable1477864refu_table_
regulable1246514regu_lable_
reliables1145904re__liables
remarkable1844084remarkable_
renewables1543404re_newables
reparable1359954repar_able_
reportable1446954reportable_
repugnances1692864repugnances
reputable1379124repu_table_
reservable1546364reservable_
restables111511424re__stables
restartable1343544restartable_
restorable1246754restor_able_
resumable1347554resu_mable_
resurfaces1543014resurfa_ces
retable91820404ret___able_
retardates1146434retarda_tes
retinals85612964ret_ina_l_s
retraces101417274ret_r_a_ces
retrainable1344354retrainable_
retrials8510824ret_ria_l_s
retunes76918404retu_n___es
returned9459134return___ed
returnee8449884return___ee
returner8397984return___er
returners9376554return__ers
returns79712594return____s
reusable10811274re_u_sable_
reverable14310364rever_able_
reversibles1682854reversibles
rewardable1643884rewardable_
ruinable1039264r__uinable_
saturable1146634satur_able_
securable1347774secur_able_
storables1146284_stor_ables
tenurable1147424tenur_able_
triturable1243764tritur_able_
tunable92511314__tu_nable_
turnsoles944204__turnsoles
turntable1144984__turntable_
unburnable1444574unburnable_
untunable1147834untu_nable_
venerables1544354vener_ables
vernacles1445074ve__rnacles
wearables14155004we_ar_ables

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.423422437.4
2DLD Change Limit148819848.75017007.9
3Display Results84840.0332545.5
 (SQL Overall)178691849.20619410.3
 
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.