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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

122 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
irrefragability2461951irrefragability_
irreformability2562034irreformability_
irrefragably21142354irrefragab_l__y_
irrefutability2293404irref_utability_
irrepealability2262284irrepealability_
irrefragable18132585irrefragab_l___e
irremovability2462945irre_movability_
irrevocability2482945irre_vocability_
refrangibility2382605__refrangibility_
erasability1668936___e_rasability_
impermeability2563916impe_rmeability_
indefeasibility2463186indefeasibility_
indefinability2384796indef_inability_
ineffability2356406i_nef__fability_
ineffaceability2862286i_neffaceability_
infrangibility2363636i__nfrangibility_
inheritability2255606inhe_ritability_
inseparability2154436inse_parability_
integrability1956586integr__ability_
irreducibility2262576irre_ducibility_
irresistibility2062666irresistibility_
irreversibility2372386irreversibility_
irritability1747486i_r__ritability_
preferability2355256_pref_erability_
readability1748076__re__adability_
reformability2354646__reformability_
refundability2253946__refundability_
repeatability2056246__repeatability_
spreadability2154406spre__adability_
treatability1747436_tre__atability_
agreeability1855167agre___eability_
alterability1747127alte_r__ability_
appealability2253967appe__alability_
bearability1847337__be__arability_
breathability2354087_bre_athability_
cleanability1955227_cle__anability_
corrigibility2163317cor__rigibility_
creditability2155697_cre_ditability_
defeasibility2254217__defeasibility_
deterrability1974997dete_r_rability_
disreputability2362117disre_putability_
drapability1986487____drapability_
filterability2153707filte_r__ability_
foreseeability2262397fore_seeability_
fragility1645567____frag__ility_
frangibility2154027____frangibility_
friability1847897____fr_iability_
heritability2047987__he_ritability_
illegibility1854427ille___gibility_
impeccability2654467impe__ccability_
impenetrability2462487impenetrability_
imperishability2772727imperishability_
implacability2454887i__mplacability_
impregnability24163237impre__gnability_
improbability2464407i__mprobability_
improvability2564597i__mprovability_
incapability2156517i___ncapability_
incomparability2662927incomparability_
incorrigibility2372267incorrigibility_
indefectibility2673317indefectibility_
indefensibility2463237indefensibility_
ineducability2155447i_ne_ducability_
ineligibility1955207i_ne_ligibility_
ineluctability2185057i_neluctability_
ineradicability2383387ineradicability_
inevitability2156967i_ne_vitability_
inexorability2585467i_ne_xorability_
inextricability2972817inextricability_
infeasibility2155727i__nfeasibility_
inflammability2663467i__nflammability_
inscrutability2163837i_nscrutability_
insurability1757227i_nsur__ability_
intelligibility2162957intelligibility_
intractability2155867i__ntractability_
invariability2155977i_nvar_iability_
irreality1245417irre____a__lity_
irrefutably1953717irref_utab_l__y_
irreparably1884087irre_parab_l__y_
marriageability23111667mar_riageability_
observability2353497obse_r_vability_
operability1848857_ope_r__ability_
overstability21125377_ove_rstability_
penetrability2055217penetr__ability_
perdurability2154687perdur__ability_
performability2663037per_formability_
permeability2157177__pe_rmeability_
predictability2454017_predictability_
pregnability2056167_pre__gnability_
presentability2164507_presentability_
preservability2453347_preservability_
preventability2464067_preventability_
profitability2355137_prof_itability_
programmability27101527_programmability_
reasonability1854797__reasonability_
recallability2054507__recallability_
reeligibility1983147__reeligibility_
refractivity2353517__refra_ctivity_
reliability1649467__re__liability_
remediability2154687__remediability_
removability2255737__re_movability_
renewability2055837__re_newability_
rentability16410197__re__ntability_
repairability2055857__repairability_
replicability2255607__replicability_
reputability1946987__re_putability_
resectability2056097__resectability_
retractility1754007__retra_ctility_
retrievability2252907__retrievability_
reusability1648477__re__usability_
roadability1757207__r__oadability_
separability1946917__se_parability_
severability2046757seve_r__ability_
sinterability1855217sinte_r__ability_
stretchability2462137stre_tchability_
tolerability1776297tole_r__ability_
trafficability2762257_trafficability_
translatability2061687translatability_
unreliability1855607unre__liability_
upgradability2253047__upgradability_
venerability2046777vene_r__ability_
verifiability2454447verif__iability_
wearability1947107__we__arability_

Search took 8 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 Limit950241227.50012669.9
3Display Results1221220.0931311.8
 (SQL Overall)1786911227.95322468.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.