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

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

88 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
horizontalities277176(None) 
horizontality2861703horizontalit__y
frontalities1555574_fr__ontalities
horizontals2351534horizontal____s
notionalities1355924noti_on_alities
originalities1464884_origin_alities
commonalities1965155co_mmon_alities
corporalities1755295cor_po_ralities
corporealities1863205cor_porealities
criminalities1754745_crimin_alities
emotionalities1673845emoti_on_alities
homosocialities2292065homosocialities
horizontal2251905horizontal_____
horizontally2761945horizontal___ly
hospitalities1854125ho__spitalities
monumentalities1962445monumentalities
mortalities1348425mor____talities
nationalities1356915nati_on_alities
optionalities1574545_option_alities
orientalizes2175755_ori_entali_zes
personalities1556475per_son_alities
polytonalities1982745polyton_alities
rationalities1357285rati_on_alities
atonalities1148406___aton_alities
biconcavities2262026__biconcavities
bimodalities1753946__bimo_dalities
brutalities1345446_br___utalities
cardinalities1654386car_din_alities
carnalities1348786car___n_alities
colinearities1553716coli__nearities
comicalities1846976comi___calities
commonalties1854256co_mmon_al_ties
communalities1954846co_mmun_alities
congenialities1774196co_ngenialities
cordialities1546146cor___dialities
criticalities1754686_cri_ticalities
dentalities1249546____dentalities
equivocalities28112076equivo_calities
fictionalities1963636fiction_alities
finalities1349906__fi__n_alities
formalities16137826for____malities
frivolities1744046_frivo___lities
heritabilities1958216heri_tabilities
homosexualities2772286homosexualities
horizonal2153006horizon_al_____
horizonless2391206horizon__l__ess
hostilities14127656h____ostilities
immortalities1754206__immortalities
irrationalities1563126irration_alities
jovialities2145166jovi____alities
linealities1148226__li__nealities
logicalities1555056logi___calities
lognormalities1761706lo_gnormalities
marginalities1654336mar_gin_alities
mentalities13410026____mentalities
microtonalities19122686microton_alities
moralities121111926mor_____alities
moribundities18111146moribun__dities
moronities1249066mor__on___ities
nonidentities1473616nonident__ities
nonmotilities1555136no_nmo_tilities
normalities13148116nor____malities
oralities91214126_or_____alities
orientalisms14105906_ori_entali_sms
orientalists12125776_ori_entali_sts
orientalize2065986_ori_entali_ze_
orientalized2264996_ori_entali_zed
orientalizing2354396_ori_entalizing
orientates1046046_ori_enta__t_es
orthogonalities1991946_orthogonalities
osmolalities1454176_o_smo_lalities
paranormalities1981786paranormalities
parfocalities2053716par_fo_calities
personalties1485156per_son_al_ties
potentialities1674206po__tentialities
primalities1548296_pri___malities
principalities2083206_principalities
printabilities1847326_pri__ntabilities
quizzicalities3361286_quizzicalities
seasonalities1353576_season_alities
socialities1349296soci____alities
tonalities101711736____ton_alities
topicalities1655586topi___calities
totalities101210786____to_talities
triaxialities2063046_tri_axialities
trivialities1555226_tri__vialities
veridicalities2063066veri_dicalities
vitalities1349096__vi___talities

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 Limit95024887.33012963.7
3Display Results88880.0631396.8
 (SQL Overall)178691887.75323048.0
 
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.