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

73 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
rectifiability246256(None) 
justifiability2961603justifiability
verifiability2454433ve_rifiability
codifiability2473604_codifiability
decidability2145744dec_i_dability
falsifiability2591734falsifiability
justiciability2861944justiciability
modifiability2463144_modifiability
practicability2553294practi_cability
recallability2054484rec_allability
recognizability3271804recognizability
reconcilability2492414reconcilability
recoverability2473194recoverability
rectifiable1853144rectifiab_l__e
reeligibility1983134reeligi_bility
reliability1649454re___liability
remediability2154674re_mediability
rentability16410184rent___ability
repairability2055834repai_rability
replicability2255594repli_cability
retrievability2252884retrievability
actability1749075_act___ability
believability2353755be_lievability
breathability2354065breat__hability
certifiably2152555certifiab_l__y
coilability1847925__coi_lability
creditability2155675cre_di_tability
cultivability2373685culti_vability
deniability1748725de___niability
desirability1847255de_si_rability
detachability2454305de_tachability
detectability2155665de_tectability
deterrability1974985de_terrability
detonability1856145de_t_onability
electability1947055elect___ability
eligibility1754825_e_ligi_bility
equitability2645775_equi_tability
excitability2655675_exci_tability
extendability2653595_extendability
extrudability2673135_extrudability
fatigability2154985_fati_gability
germinability2155045germi_nability
heritability2047975he_ri_tability
machinability2573905machi_nability
machineability26132495machineability
meltability1848685melt___ability
metastability2055565me_tastability
negligibility2063155negligi_bility
negotiability1994395ne_gotiability
perishability2365195pe_rishability
predictability2453985pre_dictability
readability1748045re___adability
reasonability1854785re_asonability
reducibility2054165re_duci_bility
reformability2354625re_formability
refundability2253935re_fundability
removability2255725re__movability
renewability2055825re__newability
repeatability2056225re_peatability
reputability1946975re__putability
resectability2056085re_sectability
resistibility1864365re_sistibility
respectability2353965respectability
reusability1648465re___usability
reversibility2154415reversi_bility
risibility1547535r___isi_bility
serviceability2462865serviceability
sociability1847915soc___iability
testability1648805test___ability
tractability1947075tract___ability
treatability1747415treat___ability
weatherability2572865weatherability
wettability1946485we_t__tability

Search took 8 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 Filter178691950240.1561145455.1
2DLD Change Limit95024737.68612363.3
3Display Results73730.0461587.0
 (SQL Overall)178691737.88822653.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.