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

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

116 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
practicalities205356(None) 
criticalities1754683cr_iticalities
farcicalities2053573farc_icalities
partialities14108033p_arti_alities
practicality2153593practicalit__y
actualities1346824__act_ualities
classicalities1862534classicalities
cyclicalities1953034_cyclicalities
erectilities1447124erecti__lities
facticities1846874_factic__ities
factualities1754534_fact_ualities
gracilities1447684grac_i__lities
parfocalities2053714p_arfocalities
partibilities1748094p_artibilities
physicalities2393644p_hysicalities
plasticities1655554plastic__ities
practicability2553324practicability
practicalness1953324practical_ness
practicalnesses2162954practicalnesses
practicals1645544practical____s
primalities1548294pr___imalities
principalities2083204principalities
prodigalities1763934pr_odigalities
punctualities1753464punct_ualities
rascalities1347224_ra__scalities
rationalities1357284_ra_tionalities
spatialities1465564spa_ti_alities
tactilities1347674_tacti__lities
tractabilities1846614tractabilities
verticalities1885214_verticalities
actabilities1649995__actabilities
actinolites1354745__actinolit_es
activities1548905__acti__vities
animalities1348995__a_nimalities
arabilities13413105ara_bi__lities
artificialities2061965artificialities
atonalities1148405__a_tonalities
atypicalities2052685_atypicalities
axialities1747735__a_xi_alities
bestialities1455495_besti_alities
brutalities1345445br_ut__alities
cardinalities1654375_cardinalities
chiralities1646515___chiralities
comicalities1846975__comicalities
criminalities1754745cr_iminalities
ductilities1446205_ducti__lities
elasticities1455105elastic__ities
ethicalities1754445__ethicalities
facilities1549825_fac_i__lities
fatalities1349445_fa_t__alities
fictionalities1963635_fictionalities
fractionalizes28134775fractionali_zes
fragilities1547165fra_gi__lities
frangibilities2054035frangibilities
frontalities1555575front__alities
functionalities2062705functionalities
illogicalities17132525illogicalities
impartialities1863495imparti_alities
impracticality2561415impracticalit__y
inactivities1755595inacti__vities
irascibilities1854835irascibilities
irrationalities1563125irrationalities
labialities1347035_la_bi_alities
lexicalities2154725__lexicalities
logicalities1555055__logicalities
marginalities1654325_marginalities
musicalities1655825__musicalities
natalities10410665_na_t__alities
nationalities1356915_na_tionalities
nuptialities1454785_nupti_alities
optimalities1654665__optimalities
oracularities1553045orac_ularities
originalities1464885or_iginalities
packabilities2346575p_ackabilities
paranormalities1981785paranormalities
parasexualities2472335parasexualities
particularities1993375p_articularities
particulates1647365p_articulat_es
perspicacities2261995perspicacities
pertinacities1754535p_ertinacities
placabilities1947635plac_abilities
placidities1665105plac_i__dities
plausibilities1873765plausibilities
politicalizes2663185politicali_zes
polytonalities1982745polytonalities
potentialities1674205potenti_alities
practicable1953835practica__ble_
practicableness2362705practicableness
practical1548845practical_____
practically20410445practical___ly
practices1557995practic_____es
preciosities1655375prec_i_osities
precocities1748165prec_oc__ities
printabilities1847325printabilities
proclivities1964685procli__vities
provincialities2262255provincialities
quizzicalities3361285quizzicalities
racializes2148465_rac_i_ali_zes
radicalises1445585_ra_dicali_ses
radicalizes2345695_ra_dicali_zes
reactivities1756175reacti__vities
retractilities1674085retracti__lities
rusticities1346845_rustic__ities
sectilities1348695_secti__lities
socialities1349295_soc_i_alities
spasticities1654625spastic__ities
specialities1656795spec_i_alities
technicalities2161955technicalities
theatricalities2061685theatricalities
topicalities1655585__topicalities
traceabilities1855875traceabilities
triaxialities2063045triaxi_alities
trivialities1555225tr_ivi_alities
typicalities1954155__typicalities
veridicalities2063065veridicalities
whimsicalities2461735whimsicalities

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.376475242.0
2DLD Change Limit950241167.12613334.8
3Display Results1161160.0931247.3
 (SQL Overall)1786911167.59523527.5
 
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.