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

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

102 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
ultravirilities188168(None) 
ultravirility1962173ultravirilit__y
ultravirile1463354ultraviril___e_
alterabilities1667335altera__bilities
cultivabilities2253055cult_ivabilities
retractilities1674075retra_ctilities
tranquilities2253905__tranquilities
trivialities1555215__trivi_alities
ultracivilized2971325ultracivili_zed
ultraviolences1971585ultravi_olences
ultraviolets15122435ultravi_olet__s
upgradabilities2162465upgradabilities
virilities1379125_____virilities
actabilities1649986act_a__bilities
adorabilities1647806adora__bilities
arabilities13413096__ara__bilities
bearabilities1748676beara__bilities
cleanabilities1856046cl_eanabilities
compatibilities2363606compatibilities
contractilities1983186contra_ctilities
corrigibilities2092766corrigibilities
credibilities1856066__credibilities
culpabilities1946006cul_pa__bilities
curabilities1649386_cura__bilities
cutabilities1649116cut_a__bilities
defeasibilities2153816defeasibilities
drapabilities1847106__drapabilities
drivabilities1947246__drivabilities
durabilities1549336_dura__bilities
eligibilities1655646el__igibilities
erasabilities1549606__erasabilities
erodibilities1656886__erodibilities
extensibilities2493466extensibilities
extralities1848226extra____lities
extrudabilities2552986extrudabilities
feasibilities1866566__feasibilities
filterabilities2053286filtera__bilities
flexibilities2564016fl__exibilities
fragilities1547156__fra__gilities
frangibilities2054036__frangibilities
gracilities1447676__gra__cilities
gravidities1644126__grav__idities
gullibilities1653766gul___libilities
illegibilities1754406il_legibilities
improvabilities24114476improvabilities
incredibilities20113666incredibilities
infeasibilities2064716infeasibilities
intangibilities1864476intangibilities
irascibilities1854816__irascibilities
labialities1347036_l__abi_alities
labilities12712236_l__a__bilities
legibilities1547476_l__egibilities
liabilities13710256_l_ia__bilities
likabilities1877276_lika__bilities
livabilities1767716_l__ivabilities
lovabilities1788006_l__ovabilities
meltabilities1749866melt_a__bilities
multiversities19151916mult_iver_sities
mutabilities1649536mut_a__bilities
notabilities14410716not_a__bilities
operabilities17510056opera__bilities
partibilities1748096_par_tibilities
placabilities1947616pl__acabilities
plausibilities1873756pl_ausibilities
playabilities2046606pl__ayabilities
pliabilities1649386pl_ia__bilities
pluralities1345686plura____lities
portabilities17410186porta__bilities
potabilities16411296pot_a__bilities
quotabilities2466626quot_a__bilities
risibilities1448626___risibilities
scurrilities1452706scur___rilities
servilities1447056_ser_v__ilities
stabilities13511756_st_a__bilities
sterilities11129006_st___erilities
suitabilities1548066suit_a__bilities
tactilities1347666__t_a_ctilities
tangibilities1655486__tangibilities
tolerabilities16116606tolera__bilities
traceabilities1855866__traceabilities
tractabilities1846586__tractabilities
trainabilities1646596__trainabilities
tranquillities2362466__tranquillities
transitivities1763506__transitivities
treatabilities1657606__treatabilities
triaxialities2063046__triaxi_alities
ultrafiltrates17171796ultrafiltrat_es
ultramarines1454306ultramar__i_nes
ultramilitant1582846ultra__militant
ultramilitants16102056ultra__militants
ultrarightist17162626ultra__rightist
ultrarightists18161776ultra__rightists
ultraviolence1881766ultravi_olence_
ultraviolet14124136ultravi_ol___et
unreliabilities1754786u_nreliabilities
untenabilities1656996unt_enabilities
usabilities1368986u__sa__bilities
utilities9610806u_t_____ilities
viridities14106906_____viridities
vulnerabilities2053086vulnera__bilities
wearabilities1848416weara__bilities
wettabilities1847776wetta__bilities

Search took 10 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.1261418182.5
2DLD Change Limit950241028.95310613.6
3Display Results1021020.0801275.0
 (SQL Overall)1786911029.15919509.9
 
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.