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

73 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
interpersonally2081871interpersonally_
interpersonal1564023interpersona_l__
impersonally1953905i___mpersonally_
internationally1873715internationally_
intrapersonal1572885intrapersona_l__
intensionally1654396inte__nsionally_
intentionally1655986inte__ntionally_
intercessional1663646intercessiona_l__
interdentally1755356interde__ntally_
internally13410096int___er__nally_
interneuronal1362696interneurona_l__
interracially1863636inter__racially_
interregional1453766interregiona_l__
intersexually2363076interse__xually_
interterminal1554306intertermina_l__
intertextually2462796interte_xtually_
personally1546946_____personally_
superpersonal1762356superpersona_l__
antipersonnel1571277ant_ipersonnel__
antiphonally2052837ant_ip__honally_
depersonalize25103647__de_personalize
impersonal1454747i___mpersona_l__
impersonality2063607i___mpersonality
impersonalize2663077i___mpersonalize
incorporeally2062237incorpor__eally_
indeterminably2272567inde_terminably_
inferentially1955487infer_e_ntially_
infernally1645267in___fer__nally_
informationally2362467informationally_
integrally1445897inte__gr___ally_
intellectually1972787intelle_ctually_
intemperately2063187intemper__ately_
interactional1557007interactiona_l__
intercensal1356147intercens__a_l__
intercessory1753177intercesso___ry_
interculturally2072327interculturally_
interestedly1653697inter_e_s_tedly_
interestingly1753997inter_e_stingly_
interferometry2261817interfer_ometry_
interferon1346847interfer_on_____
interferons1446747interfer_on____s
interjectional23195607interjectiona_l__
intermarginal1672907intermargina_l__
intermetallic1762847interme___tallic
interminably1956437int___erminably_
international1357677internationa_l__
internationals1454247internationa_l_s
interoperable1763577interoper___abl_e
interpermeate1754237interper_mea__te
interpermeated1963217interper_mea_ted
interpermeates1863467interper_mea_tes
interpermeating2063077interper_meating
interpretable1753947interp_r_etabl_e
interpretively2262937interp_retively_
interrenal1049817inter__r_ena_l__
intersectional16146257intersectiona_l__
intersensory1552757intersenso___ry_
interspersing1654487interspersin____g
interspersion1564397interspersion_____
interspersions1663877interspersion____s
interstitially1763177inter_stitially_
intertidally1655727int___ertidally_
interzonal1946817int___erzona_l__
intestinally1556017int___estinally_
intracerebrally22101387intracerebrally_
intracranially19112347int_racranially_
intradermally1962507intrader__mally_
intranasally1562967int_ranas__ally_
intrinsically1854297int_r_insically_
nonpersonal13114437_n_onpersona_l__
personalty1555287_____personalty_
treasonably1652647__t_r_easonably_
unreasonably1753897un__r_easonably_

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.346516448.0
2DLD Change Limit95024739.37310138.1
3Display Results73730.0631158.7
 (SQL Overall)178691739.78218267.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.