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 “incalculabilitya” with Change Limit: [1] [2] [3] [4] [5] [6] [7]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

34 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
incalculability2462211incalculability_
incalculably2163004incalculab_l__y_
inalienability1954555in_alienability_
inalterability1954565in_alterability_
incalculable1853255incalculab_l___e
incapability2156515inca___pability_
ineluctability2185055in_eluctability_
infallibility2164305infal__libility_
recallability2054505recal__lability_
analyzability3053426an_al_yzability_
coagulability2153326__coagulability_
excludability2852696exc_l_udability_
impalpability2454116impal__pability_
implacability2454886implac__ability_
inadvisability2374196in_advisability_
inaudibility1855306in_a__udibility_
incomparability2662926incomparability_
ineducability2155446in__educability_
inflammability2663466in_flammability_
insatiability1856496insa__tiability_
inscrutability2163836in_scrutability_
insociability2056226in_soc_iability_
insolubility1754096insol_u__bility_
insurability1757226in___surability_
intolerability1964526intol_erability_
intractability2155866intrac_tability_
invariability2155976inva__riability_
inviolability2155116in__violability_
invulnerability2372216invulnerability_
localizability3062186local_izability_
reconcilability2492416reconcilability_
unalterability1963476un_alterability_
unavailability2263626un_availability_
unpalatability2163096unpal_atability_

Search took 9 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 Filter178691658740.673265514.1
2DLD Change Limit65874348.2038030.5
3Display Results34340.046739.1
 (SQL Overall)178691348.92220028.1
 
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.