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 “perfectibility” 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
perfectibility266326(None) 
perceptibility2562942perceptibility
perfectivity2563843perfect__ivity
affectability2663854_affectability
deductibility2253514de_ductibility
defeasibility2254204de_feasibility
defensibility2254454de_fensibility
delectability2155674de_lectability
detectability2155664de_tectability
electability1947054_e_lectability
erectility1546264_er_ect__ility
indefectibility2673314indefectibility
partibility1847114par___tibility
perfectible2053434perfectib_l__e
perfectively2554834perfectivel__y
perfectivities2483874perfectivities
performability2663034performability
permeability2157174perme__ability
permissibility2362944permissibility
predictability2454014predictability
preferability2355254prefe_rability
presentability2164504presentability
preventability2464064preventability
resectability2056094re_sectability
respectability2353974respectability
conductibility2462815conductibility
convertibility2463275convertibility
corruptibility2362385corruptibility
credibility1955505_cr_e_dibility
destructibility2372325destructibility
digestibility2053725_digestibility
effectivity25103665_effect__ivity
effectuality2382315_effect_uality
erodibility1755965_er__odibility
extensibility2553905_extensibility
feasibility1945955___feasibility
heritability2047985her__itability
infeasibility2155725_infeasibility
irascibility1985415_irasc_ibility
irrefutability2293405irrefutability
marketability2454135marke_tability
patentability2054785p_atentability
penetrability2055215pe_netrability
perceptibly2253155perceptib_l__y
perceptivity2453425percept__ivity
perdurability2154685per_durability
perfectionism2253985perfecti_onism
perfectionist2055335perfecti_onist
perfectionistic2471905perfectionistic
perfectionists2164015perfectionists
perfectly1944115perfect___l__y
perishability2365235per_ishability
portability1849565por___tability
practicability2553325p_r_acticability
practicality2153595p_r_acticality
pregnability2056165p_r_egnability
preservability2453345preservability
printability1946865p_r_intability
processibility2363055processibility
profitability2355135p_rofitability
promotability2254805p_romotability
reducibility2054175re_duc_ibility
refrangibility2382605refrangibility
rentability16410195__r_entability
repeatability2056245re_peatability
repressibility2173735repressibility
resistibility1864375re_sistibility
reversibility2154425re_versibility
serviceability2462865serviceability
suggestibility2161535suggestibility
susceptibility23132185susceptibility
tractability1947095_tr_actability
treatability1747435_tr_eatability

Search took 7 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.360496363.9
2DLD Change Limit95024735.67016759.1
3Display Results73730.0631158.7
 (SQL Overall)178691736.09329327.3
 
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.