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

49 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
nonrefundable196204(None) 
nonrefillable1862493nonrefillable
nonreturnable15102483nonreturnable
nonreusable1354713nonre_u_sable
refundable1643803___refundable
nondeferrable1962544nondeferrable
nondegradable1862034nondegradable
nonexpendable2561784nonexpendable
nonrecyclable2262204nonrecyclable
nonredundant1462044nonredunda_nt
nonrenewable1782634nonre_newable
nonrepayable1952584nonre_payable
nonreturnables16101504nonreturnables
boundable1444845bo____undable
commendable2054345comme__ndable
compoundable2161585co_mpoundable
condemnable1854055conde_mn_able
condensable16115395conde__nsable
defendable1754985___defendable
indefinable1756355_indefin_able
irrefutable1653985_irrefu_table
nonaccountable2071145nonaccountable
nonbreakable2062135nonbre__akable
nonburnable1553385non__burnable
noncrushable1962575non_crushable
nondeductible1962395nondeductible
nondepletable1862345nondepletable
nondetachable2162135nondetachable
nondurable1346095non__du_rable
nonedible1245545non_e___dible
nonfeudal1343695nonfe_u_da_l_
nonmeasurable1762745nonmeasurable
nonnegotiable1661945nonnegotiable
nonperishable2072855nonperishable
nonrecyclables2371435nonrecyclables
nonreversible1872435nonreversible
nonshrinkable2261525nonshrinkable
nonsinkable1753505non__sinkable
nonusable1146765non___u_sable
refinable1438625___refin_able
refusable1476685___refu_sable
refutable1477865___refu_table
soundable1245985so____undable
unbendable1545815_unbe__ndable
undefinable1746385_undefin_able
undependable1853925_undependable
unfindable1644865_un__findable
unreadable1347715_unre__adable
unreturnable1453645_unreturnable

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.1561145455.1
2DLD Change Limit124790498.93613964.9
3Display Results49490.0301633.3
 (SQL Overall)178691499.12219589.0
 
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.