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

58 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
retroreflection2011167(None) 
retroflection1854042retro__flection
retroreflective2371302retroreflective
retroreflector1971122retroreflect_or
retroflections1953873retro__flections
retroreflectors2071023retroreflectors
antireflection19102414ant_ireflection
retroflexion2262064retro__fle_xion
retrospection1784314retro__spection
recollection1654855re_co__llection
reelection12198635re____e_lection
reflection15168995_____reflection
retroaction1347365retro____action
retrodiction1555655retro___diction
retroflexions2362045retro__fle_xions
retrospections1894175retro__spections
antireflective2271986ant_ireflective
antirejection2283216ant_ire_jection
autoinfection1862016aut_oinf_ection
deflection16147736_____deflection
dereliction1444576de___re_liction
genuflection1851616ge___nuflection
intellection1466166int___ellection
interelectron1564136int_ere_lectron
introjection2156206intro___jection
introspection1764626intro__spection
neurosecretion1671526neurosecre_tion
nonelection1347206___none_lection
perfection1748366pe___r_f_ection
petrifaction1953726pet__rif_action
preelection15136486____preelection
prelection141511296____pre_lection
preselection16154886__prese_lection
putrefaction1952466put__ref_action
rarefaction1652656___raref_action
recollections1754726re_co__llections
reconnection1655996re_co__nnection
redirection1446056re_dir___ection
reelections13167946re____e_lections
refection141512286_____ref_ection
reflections16178556_____reflections
reforestation1654576re_fore_station
reformulation1853976re_formul_ation
reinfection1645446re___inf_ection
reproduction1765656repro___duction
resurrection1453356re_sur__rection
retortion949676ret_or_____tion
retraction121310536ret__r___action
retranslation1354686retr_ansl_ation
retroactions1447076retro____actions
retrocession1494456retro___cession
retrodictions1655536retro___dictions
retrogradation16151886retro_gradation
retrogression14103426retro__gression
retrospecting1863456retro__specting
retrospective2083516retro__spective
retroversion1573676retro___version
transfection1765396__transf_ection

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 Filter178691950240.343520965.0
2DLD Change Limit95024587.84312115.8
3Display Results58580.0461260.9
 (SQL Overall)178691588.23221706.9
 
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.