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

48 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
periodontally196217(None) 
periodontal1463162periodonta_l_
periodically2047593period_ically
periodontology2171093periodontology
peritoneally1753233peri_toneally
aperiodically2154194aperiod_ically
horizontally2761944hori_zontally
meridionally1852854meridion_ally
perinatally1653444peri__natally
periodontics1762434periodont_ics
periodontist1563394periodont_ist
periodontists1662544periodontists
personally1546944per__son_ally
accidentally2062735acci_dentally
antidotally1553525anti_do_tally
ceremonially1953385cer_emonially
detrimentally1963765detri_mentally
endodontically2192645_endodontically
erosionally1454665_erosion_ally
evidentially1954055_evi_dentially
experimentally2863075experi_mentally
frontally1546115_fr___ontally
incidentally1854125inci_dentally
occidentally2062785occi_dentally
operationally1854645operation_ally
orientally1346215_ori__entally
pardonably1863115par__don_ably
parentally1546205par___entally
penitentially1854295peni_tentially
pentagonally1862085pentagon_ally
perennially1654605per__ennially
periodical1546815period_ica_l_
periodicals1664075period_ica_ls
peripherally2262475peri_pherally
peritoneal1255115peri_tonea_l_
perorally1448225per___o_rally
personalty1555285per__son_alty
pivotally1743645p__i_vo_tally
positionally1754925position_ally
presidentially2063225presidentially
prodigally1744385p_r_od_igally
prudentially1854155p_r_udentially
regionally1445535regi__on_ally
residentially1773845resi_dentially
semitonally1654685semi_ton_ally
seriocomically2373105seriocomically
trigonally1454065_tri_gon_ally
veridically2046085veri_d_ically

Search took 9 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 Filter1786911247900.390458182.1
2DLD Change Limit124790488.56314573.2
3Display Results48480.0301600.0
 (SQL Overall)178691488.98319892.1
 
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.