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
frontalities1555554_fr__ontalities
horizontals2351534horizontal____s
notionalities1355924noti_on_alities
originalities1464884_origin_alities
commonalities1965135co_mmon_alities
corporalities1755285cor_po_ralities
corporealities1863205cor_porealities
criminalities1754735_crimin_alities
emotionalities1673845emoti_on_alities
homosocialities2292065homosocialities
horizontal2251905horizontal_____
horizontally2761945horizontal___ly
hospitalities1854125ho__spitalities
monumentalities1962445monumentalities
mortalities1348415mor____talities
nationalities1356895nati_on_alities
optionalities1574545_option_alities
orientalizes2175725_ori_entali_zes
personalities1556475per_son_alities
polytonalities1982745polyton_alities
rationalities1357265rati_on_alities
atonalities1148396___aton_alities
biconcavities2262016__biconcavities
bimodalities1753936__bimo_dalities
brutalities1345426_br___utalities
cardinalities1654356car_din_alities
carnalities1348766car___n_alities
colinearities1553716coli__nearities
comicalities1846956comi___calities
commonalties1854236co_mmon_al_ties
communalities1954826co_mmun_alities
congenialities1774196co_ngenialities
cordialities1546126cor___dialities
criticalities1754676_cri_ticalities
dentalities1249536____dentalities
equivocalities28112066equivo_calities
fictionalities1963626fiction_alities
finalities1349886__fi__n_alities
formalities16137816for____malities
frivolities1744036_frivo___lities
heritabilities1958196heri_tabilities
homosexualities2772286homosexualities
horizonal2153006horizon_al_____
horizonless2391206horizon__l__ess
hostilities14127646h____ostilities
immortalities1754206__immortalities
irrationalities1563126irration_alities
jovialities2145166jovi____alities
linealities1148206__li__nealities
logicalities1555056logi___calities
lognormalities1761696lo_gnormalities
marginalities1654326mar_gin_alities
mentalities13410006____mentalities
microtonalities19122686microton_alities
moralities121111926mor_____alities
moribundities18111146moribun__dities
moronities1249056mor__on___ities
nonidentities1473616nonident__ities
nonmotilities1555136no_nmo_tilities
normalities13148106nor____malities
oralities91214116_or_____alities
orientalisms14105886_ori_entali_sms
orientalists12125746_ori_entali_sts
orientalize2065976_ori_entali_ze_
orientalized2264986_ori_entali_zed
orientalizing2354386_ori_entalizing
orientates1046026_ori_enta__t_es
orthogonalities1991946_orthogonalities
osmolalities1454176_o_smo_lalities
paranormalities1981786paranormalities
parfocalities2053716par_fo_calities
personalties1485156per_son_al_ties
potentialities1674196po__tentialities
primalities1548286_pri___malities
principalities2083206_principalities
printabilities1847276_pri__ntabilities
quizzicalities3361286_quizzicalities
seasonalities1353566_season_alities
socialities1349286soci____alities
tonalities101711736____ton_alities
topicalities1655586topi___calities
totalities101210766____to_talities
triaxialities2063046_tri_axialities
trivialities1555216_tri__vialities
veridicalities2063066veri_dicalities
vitalities1349086__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.250714764.0
2DLD Change Limit95024889.31310203.4
3Display Results88880.0631396.8
 (SQL Overall)178691889.62618563.4
 
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.