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

62 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
nonperishable207285(None) 
nonperishables2171631nonperishables
imperishable2153353_imperishable
noncrushable1962573non_crushable
perishable1745263___perishable
cherishable2152354__cherishable
conversable1846354conver_s_able
imperishables2261774_imperishables
imperishably2462854_imperishably
nondetachable2162134nondetachable
nonrefillable1862494nonrefillable
nonreusable1354714nonre_us_able
nonshrinkable2261524nonshrinkable
perishables1852824___perishables
compensable1955195compe_ns_able
conceivable2054995conce_i_vable
condensable16115395conde_ns_able
conferrable1845825confer__rable
confessable1854855confe__ssable
confiscable2053675con__fiscable
contestable1546895conte__stable
contrastable1654435con_trastable
copyrightable266795co_pyrightable
inheritable1647245_inheri_table
inoperable1448175ino_per___able
nonarable1149055non_ar___able
nonbreakable2062135non_breakable
nonburnable1553385nonbur__nable
nondeferrable1962545nondeferrable
nondegradable1862035nondegradable
nondepletable1862345nondepletable
nondisabled1552385non__dis_abled
nondurable1346095nondur___able
nonedible1245545non_edi___ble
nonliable1147675non__li__able
nonmeasurable1762745nonmeasurable
nonnegotiable1661945nonnegotiable
nonpermissive2061405nonpermis_sive
nonpersonal13114435nonper_sonal_
nonpolarizable2791285nonpolari_zable
nonrecyclable2262205nonrecyclable
nonrefundable1962045nonrefundable
nonrenewable1782635nonre_newable
nonrepayable1952585nonre_payable
nonresistance1562655nonresistance
nonreturnable15102485nonreturnable
nonserial9611955nonseri__a_l_
nonserials1068025nonseri__a_ls
nonsinkable1753505non__sinkable
nonusable1146765non___us_able
nonviable1446265non__vi__able
operable12410325_o_per___able
perusable1347455___perus_able
ponderable1546085ponder___able
punishable1743285___punishable
relishable1544525___relishable
replenishable2061105replenishable
uncrushable1853575_un_crushable
unprintable1555215_unp_rintable
unpublishable2261295_unpublishable
unverifiable2053285_unverifiable
vanquishable2961175van_quishable

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 Limit124790629.37613309.5
3Display Results62620.0302066.7
 (SQL Overall)178691629.79618241.2
 
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.