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

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
indefeasibility2463151indefeasibility_
indefensibility2463202indefensibility_
defeasibility2254183__defeasibility_
indefectibility2673283indefectibility_
infeasibility2155683in__feasibility_
defensibility2254444__defensibility_
indefeasibly21103174indefeasib_l__y_
defeasibilities2153815__defeasibilities
feasibility1945935____feasibility_
inaccessibility2482445inaccessibility_
indefeasible18103445indefeasib_l___e
indefensibly21113685indefensib_l__y_
indefinability2384775indef_inability_
indelibility1856215ind__e_libility_
indigestibility2262545indigestibility_
indivisibility2373625ind_ivisibility_
ineffability2356385in_effa__bility_
infeasibilities2064715in__feasibilities
infusibility2055765in__f_usibility_
insensibility1875885in__sensibility_
intervisibility2363215intervisibility_
irreversibility2372365irreversibility_
defensibilities2164046__defensibilities
impressibility2364366i_mpressibility_
inadmissibility2392356inadmissibility_
incompatibility2662596incompatibility_
incredibility2154686in_cre_dibility_
indefectibly2353476indefectib_l__y_
indefensible18104076indefensib_l___e
inducibility2055486ind___ucibility_
ineducability2155426ineduca__bility_
ineffaceability2862266in_effaceability_
ineligibility1955176in_e_ligibility_
infallibility2164276in__fallibility_
inflexibility2883916in__flexibility_
infrangibility2363596in__frangibility_
inseparability2154416inse_parability_
integrability1956566integra__bility_
intelligibility2162936intelligibility_
invisibility2055996in___visibility_
irrefragability2461936irrefragability_
irrepealability2262276irrepealability_
reversibility2154416__reversibility_

Search took 6 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.0931921408.6
2DLD Change Limit65874435.09312934.2
3Display Results43430.0331303.0
 (SQL Overall)178691435.21934238.6
 
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.