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

46 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
specifiable207246(None) 
pacifiable1943072_pacifiable
unspecifiable2262312unspecifiable
rectifiable1853143_rectifiable
saponifiable1961423saponifiable
specifically2453473specifically
verifiable1843683_verifiable
certifiable1852914certifiable
decidable1547224_deci_dable
falsifiable1951954falsifiable
identifiable1882144identifiable
justifiable2352574justifiable
modifiable1852204_modifiable
notifiable1553674_notifiable
peccable1648124_pec__cable
perishable1745264_perishable
pitiable1238294_p__itiable
precipitable2053404precipitable
qualifiable2551884qualifiable
satisfiable1651834satisfiable
securable1347774s_ec_urable
seisable10311374s_e_i_sable
seizable1938724s_e_i_zable
shiftable1744894s__hiftable
sniffable1743774s__niffable
sociable1239504s_oc__iable
speakable1745374spe__akable
special11310304spec__ia_l_
specialer1344734spec__ia_ler
specially1647344spec__ially
specials1238034spec__ia_ls
speciate12209584spec__ia_te
specific1744704specifi___c
specificity2382634specificity
specifics1843934specifi__cs
specified1746254specifi__ed
specifier1645684specifi__er
specifiers1743804specifi_ers
specifies1647574specifi__es
spectacle1544084spec__tacle
spendable1446464spe__ndable
spillable1345354sp__illable
spoilable1345164sp_oi_lable
unifiable1447344__unifiable
unverifiable2053284unverifiable
vitrifiable1952064vitrifiable

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.483369960.7
2DLD Change Limit148819469.34315928.4
3Display Results46460.0162875.0
 (SQL Overall)178691469.84218156.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.