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

43 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
sinterabilities17114611sinterabilities_
filterabilities2053283filterabilities_
integrabilities1885503_integrabilities_
alterabilities1667334_alterabilities_
insurabilities1676894_insurabilities_
penetrabilities1965324penetrabilities_
severabilities1947434s_everabilities_
sinterability1855204sinterabilit___y
solderabilities1873374solderabilities_
untenabilities1656994_untenabilities_
venerabilities1967354ven_erabilities_
deterrabilities1875385_deterrabilities_
enumerabilities1954065enumerabilities_
honorabilities1955945hon_orabilities_
inabilities13412735_in___abilities_
incapabilities2056205_incapabilities_
indelibilities1755555_indelibilities_
ineffabilities2256155_ineffabilities_
inexorabilities2454675_inexorabilities_
infertilities1656205_infer_tilities_
instabilities1549845_in_stabilities_
integralities1495505_integra__lities_
internalities1358635_inter_nalities_
invariabilities2055125_invariabilities_
inviabilities1848815_in_viabilities_
literalities1267545li_tera__lities_
liveabilities1846755li_ve_abilities_
mensurabilities1964415mensurabilities_
operabilities17510055__operabilities_
preferabilities2254605preferabilities_
printabilities1847275print__abilities_
renewabilities1956205ren_ewabilities_
rentabilities15411235rent__abilities_
separabilities1847345s_eparabilities_
sewabilities1748935s___ewabilities_
shareabilities1955215share_abilities_
squeezabilities3562305squeezabilities_
stabilities13511755s__t__abilities_
sterilities11129005s__ter__ilities_
suitabilities1548065suit__abilities_
tenabilities14911485___tenabilities_
tolerabilities16116605_tolerabilities_
vulnerabilities2053085vulnerabilities_

Search took 4 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 Filter178691435480.1401276364.3
2DLD Change Limit43548433.76611563.5
3Display Results43430.0301433.3
 (SQL Overall)178691433.93645399.1
 
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.