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

65 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
internationally1873711internationally_
intentionally1655983inte_n_tionally_
international1357663internationa_l__
internationals1454233internationa_l_s
informationally2362464informationally_
intensionally1654394inte_n_sionally_
generationally1883005gener_ationally_
ideationally1674875i_de__ationally_
inspirationally2072535inspirationally_
intentional11128835inte_n_tiona_l__
intentionality17113445inte_n_tionality
interactional1556995interactiona_l__
interpersonally2081875interpersonally_
interracially1863635interraci__ally_
interstitially1763175inter_stitially_
intertidally1655725inter__ti_dally_
intestinally1556015inte__sti_nally_
intonational1256005int_onationa_l__
irrationally1555245i___rrationally_
observationally2371995observationally_
operationally1854645_oper_ationally_
unintentionally1872735uninte_n_tionally_
antenatally1453046ante_nat___ally_
antinational1297456ant_inationa_l__
antinationalist15163526ant_inationalist
antirational1278456antir_ationa_l__
antirationalism17214036antir_ationalism
antirationalist15214426antir_ationalist
antirationality1872596antir_ationality
conventionally2254956conve_n_tionally_
equationally2453826___equationally_
extensionally2362886exte_n_sionally_
inclinational1553926inclinationa_l__
inertially1349326in_er__ti__ally_
inferentially1955466inferenti__ally_
inflectionally2262946in_flectionally_
informational1854336informationa_l__
insertional1147456inser__tiona_l__
institutionally1872136institutionally_
intensional11146566inte_n_siona_l__
intensionality17152946inte_n_sionality
interestingly1753996interesti_n_gly_
interjectional23195596interjectiona_l__
interminably1956436inter__mi_nably_
internally13410096inter_____nally_
interneuronal1362696interneurona_l__
interregional1453756interregiona_l__
interrogational1693906interrogationa_l__
intersectional16146246intersectiona_l__
intrathecally2163196int_r_athecally_
intravitally1854266int_r_avi_tally_
motivationally2262496mot_ivationally_
mutationally1754276mut___ationally_
nationally1348426_____nationally_
navigationally2162236_navigationally_
nutritionally16103546_nutr_itionally_
orientationally1872056orientationally_
rationally1349426____r_ationally_
relationally1555076__re_lationally_
sensationally1654306__sensationally_
situationally1653396sit__uationally_
supernational1555616supernationa_l__
unemotionally1853766un_e_motionally_
untraditionally1982836untraditionally_
variationally1953006__variationally_

Search took 6 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 Filter178691658740.0931921408.6
2DLD Change Limit65874655.29612438.4
3Display Results65650.0461413.0
 (SQL Overall)178691655.43532877.8
 
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.