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 “impartialities” 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.

100 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
impartialities186349(None) 
partialities14108042__partialities
immortalities1754203immort_alities
impartiality1953043impartialit__y
spatialities1465563_spa_tialities
immaterialities1962874immaterialities
immoralities1655734immor__alities
imparities14108644impar____ities
impassibilities21184674impassibilities
impassivities2062954impassi_vities
impersonalities1963674impersonalities
importunities1762724import_unities
infantilities1665264infanti_lities
infertilities1656214inferti_lities
marginalities1654344_m_arginalities
mortalities1348424_m_ort_alities
nuptialities1454784nup__tialities
partibilities1748104__partibilities
actualities1346825___actualities
amiabilities16109895amia_bi_lities
amoralities1347425am_or__alities
axialities1747735___a_xialities
bestialities1455495__bestialities
capabilities1848825capa_bi_lities
cardinalities1654395__cardinalities
carnalities1348785__car_nalities
commercialities2363315commercialities
comparabilities2374375comparabilities
compatibilities2363625compa_tibilities
cordialities1546155__cordialities
essentialities1473245essentialities
factualities1754535__factualities
farcicalities2053575__farcicalities
fatalities1349445__fa_t_alities
fertilities1448825__ferti_lities
imbecilities1853655im_beci_lities
immaturities1652705imma_t_urities
immobilities1846265im_mobi_lities
immortalises1693935immort_ali_ses
immortalizes2593915immort_ali_zes
impalpabilities2363955impalpabilities
imparadises1653105impar__adi_ses
impartation15156105impart_a__tion
impartations16135435impart_ati_ons
impartial1345185impartial_____
impartially1853815impartial___ly
impartible1644365impartibl___e_
impassabilities21155265impassabilities
imperialisms18105905imper_iali_sms
imperialistic1962945imper_ialisti_c
imperialists16105405imper_iali_sts
impertinencies2062145impertinencies
impetuosities1762145imp_etuosities
implacabilities2354015implacabilities
importancies1853275import_a_ncies
impossibilities21174235impossibilities
improbabilities23114295imp_robabilities
improbities1754695imp_r__obities
improvabilities24114475imp_rovabilities
impudicities1963235imp_udi_cities
impulsivities2062015impulsi_vities
impurities14136445impur____ities
imputabilities2056625imputabilities
inabilities13412755i_na_bi_lities
inactivities1755595i_nacti_vities
informalities1864295infor_malities
insatiabilities1775505insa_tiabilities
internalities1358635inter_nalities
inutilities1148185i__nuti_lities
invariabilities2055125invar_iabilities
irrationalities1563125irra_tionalities
irrealities1146215i___rrealities
labialities1347035__la_bialities
mammalities1444855_m_a_mmalities
materialities1566395_materialities
mentalities13410025_m_ent_alities
moralities121111925_m_or__alities
motilities12410585_m__oti_lities
mutualities1395835_m__utualities
natalities10410665__na_t_alities
optimalities1654665_op__timalities
parfocalities2053715__parfocalities
partiality1546785__partialit__y
patrilinies1354175__patri_linies
pertinacities1754535__pertinacities
potentialities1674205potentialities
practicalities2053565_practicalities
primalities1548295__p_rimalities
separabilities1847345separabilities
spasticities1654625_spasti_cities
specialities1656795_sp_ecialities
spiralities1348015_spir__alities
spiritualities1663695_spiritualities
tactilities1347675__tacti_lities
temporalities1753495tempor__alities
theatricalities2061685theatricalities
triaxialities2063045tria_xialities
verticalities1885215__verticalities
virtualities1554695__virtualities
volatilities1546515vola_ti_lities

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.343520965.0
2DLD Change Limit950241006.29615092.8
3Display Results1001000.0631587.3
 (SQL Overall)1786911006.70226662.3
 
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.