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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
horizontalities2771761horizontalities_
horizontality2861704horizontalit___y
frontalities1555575_fr__ontalities_
horizontals2351545horizontal____s_
notionalities1355925noti_on_alities_
originalities1464885_origin_alities_
commonalities1965156co_mmon_alities_
corporalities1755296cor_po_ralities_
corporealities1863206cor_porealities_
criminalities1754746_crimin_alities_
emotionalities1673846emoti_on_alities_
homosocialities2292066homosocialities_
horizonless2391206horizon__l___ess
horizontal2251906horizontal______
horizontally2761946horizontal____ly
hospitalities1854126ho__spitalities_
monumentalities1962446monumentalities_
mortalities1348426mor____talities_
nationalities1356916nati_on_alities_
optionalities1574546_option_alities_
orientalizes2175756_ori_entali_zes_
personalities1556476per_son_alities_
polytonalities1982746polyton_alities_
rationalities1357286rati_on_alities_
atonalities1148407___aton_alities_
biconcavities2262027__biconcavities_
bimodalities1753947__bimo_dalities_
brutalities1345447_br___utalities_
cardinalities1654387car_din_alities_
carnalities1348787car___n_alities_
colinearities1553717coli__nearities_
comicalities1846977comi___calities_
commonalties1854257co_mmon_al_ties_
communalities1954847co_mmun_alities_
congenialities1774197co_ngenialities_
cordialities1546157cor___dialities_
criticalities1754687_cri_ticalities_
dentalities1249547____dentalities_
equivocalities28112077equivo_calities_
fictionalities1963637fiction_alities_
finalities1349907__fi__n_alities_
formalities16137827for____malities_
frivolities1744047_frivo___lities_
heritabilities1958217heri_tabilities_
homosexualities2772297homosexualities_
horizonal2153007horizon_al______
hostilities14127657h____ostilities_
immortalities1754207__immortalities_
irrationalities1563127irration_alities_
jovialities2145167jovi____alities_
linealities1148227__li__nealities_
logicalities1555057logi___calities_
lognormalities1761707lo_gnormalities_
marginalities1654337mar_gin_alities_
mentalities13410027____mentalities_
microtonalities19122687microton_alities_
moralities121111927mor_____alities_
moribundities18111147moribun__dities_
moronities1249067mor__on___ities_
nonidentities1473617nonident__ities_
nonmotilities1555137no_nmo_tilities_
normalities13148117nor____malities_
oralities91214127_or_____alities_
orientalism13126497_ori_ental__i_sm
orientalisms14105907_ori_entali_sms_
orientalist1197827_ori_ental__i_st
orientalists12125777_ori_entali_sts_
orientalize2065987_ori_entali_ze__
orientalized2264997_ori_entali_ze_d
orientalizing2354397_ori_entalizi_ng
orientates1046047_ori_enta__t_es_
orthogonalities1991947_orthogonalities_
osmolalities1454177_o_smo_lalities_
paranormalities1981787paranormalities_
parfocalities2053717par_fo_calities_
personalties1485157per_son_al_ties_
potentialities1674207po__tentialities_
primalities1548297_pri___malities_
principalities2083207_principalities_
printabilities1847327_pri__ntabilities_
quizzicalities3361287_quizzicalities_
seasonalities1353577_season_alities_
socialities1349297soci____alities_
tonalities101711737____ton_alities_
topicalities1655587topi___calities_
totalities101210787____to_talities_
triaxialities2063047_tri_axialities_
trivialities1555227_tri__vialities_
veridicalities2063067veri_dicalities_
vitalities1349097__vi___talities_

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.360496363.9
2DLD Change Limit95024909.15610378.3
3Display Results90900.0601500.0
 (SQL Overall)178691909.57618660.3
 
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.