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
deductibility2253504de_ductibility
defeasibility2254194de_feasibility
defensibility2254444de_fensibility
delectability2155674de_lectability
detectability2155664de_tectability
electability1947054_e_lectability
erectility1546264_er_ect__ility
indefectibility2673304indefectibility
partibility1847094par___tibility
perfectible2053424perfectib_l__e
perfectively2554834perfectivel__y
perfectivities2483874perfectivities
performability2663004performability
permeability2157144perme__ability
permissibility2362934permissibility
predictability2453984predictability
preferability2355234prefe_rability
presentability2164484presentability
preventability2464044preventability
resectability2056084re_sectability
respectability2353964respectability
conductibility2462805conductibility
convertibility2463275convertibility
corruptibility2362375corruptibility
credibility1955495_cr_e_dibility
destructibility2372325destructibility
digestibility2053715_digestibility
effectivity25103665_effect__ivity
effectuality2382315_effect_uality
erodibility1755945_er__odibility
extensibility2553895_extensibility
feasibility1945945___feasibility
heritability2047975her__itability
infeasibility2155715_infeasibility
irascibility1985395_irasc_ibility
irrefutability2293395irrefutability
marketability2454125marke_tability
patentability2054775p_atentability
penetrability2055205pe_netrability
perceptibly2253145perceptib_l__y
perceptivity2453425percept__ivity
perdurability2154665per_durability
perfectionism2253985perfecti_onism
perfectionist2055335perfecti_onist
perfectionistic2471905perfectionistic
perfectionists2164015perfectionists
perfectly1944105perfect___l__y
perishability2365195per_ishability
portability1849535por___tability
practicability2553295p_r_acticability
practicality2153595p_r_acticality
pregnability2056135p_r_egnability
preservability2453325preservability
printability1946845p_r_intability
processibility2363025processibility
profitability2355105p_rofitability
promotability2254775p_romotability
reducibility2054165re_duc_ibility
refrangibility2382585refrangibility
rentability16410185__r_entability
repeatability2056225re_peatability
repressibility2173715repressibility
resistibility1864365re_sistibility
reversibility2154415re_versibility
serviceability2462865serviceability
suggestibility2161525suggestibility
susceptibility23132185susceptibility
tractability1947075_tr_actability
treatability1747415_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.1231452772.4
2DLD Change Limit95024736.25015203.8
3Display Results73730.0461587.0
 (SQL Overall)178691736.41927837.8
 
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.