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 “reflections” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
reflections1617855(None) 
deflections17187321deflections
reelections13167941reelections
refections151811641ref_ections
reflection15168991reflection_
defections161510202def_ections
deflection16147732deflection_
elections112414972_e_lections
flections14239212__flections
inflections1646992inflections
prelections151210472pre_lections
reelection12198632reelection_
refection141512282ref_ection_
reflations13311232refl_ations
reflecting1638822reflecti_ng
reflectional1753992reflectional
reflectors1545502reflect_ors
reflexions2043302refle_xions
refractions16127722refractions
rejections191510102re_jections
relictions12310022re_lictions
repletions1247472reple_tions
resections121513032re_sections
selections12310872se_lections
affections1845893_affections
afflictions1943403afflictions
bilections14136503_bilections
bolections14137293_bolections
collections1547933collections
defecations1779003def_ecations
defection151610643def_ection_
deflations1439713defl_ations
deflecting1736503deflecti_ng
deflectors1654773deflect_ors
deflexions2142563defle_xions
dejections20168353de_jections
deletions102610933de_le_tions
depletions1355743deple_tions
detections131410043de_tections
ejections18249963_e_jections
election102015353_e_lection_
electrons112411763_e_lectrons
erections112515213_e_rections
evections142510693_e_vections
exsections1947633_exsections
flection13239563__flection_
genuflections1951513genuflections
infections15510233inf_ections
inflection1547633inflection_
inflictions1645443inflictions
lections102413843___lections
perfections1848143perfections
predilections1853563predilections
preelection15136483preelection_
prelection141511293pre_lection_
preselections17144443preselections
reactions11711713re__actions
receptions1449743re_ceptions
recollections1754723recollections
recreations13412253recreations
redactions1359133re_dactions
redirections1546183redirections
reductions1359583re_ductions
reelecting1338783reelecti_ng
refecting152413353ref_ecti_ng
reflation12412333refl_ation_
reflective1857123reflecti_ve
reflector1445733reflect_o_r
reflects13288873reflect___s
reflexion1943613refle_xion_
refraction15137903refraction_
refutations1448673refutations
reinfections1745323reinfections
reinjections2144403reinjections
rejection181710253re_jection_
relations92418333re_l_ations
relegations1248973re_legations
reliction11310693re_liction_
relocations13311143re_locations
repletion1147693reple_tion_
replications16811053replications
resection111613273re_section_
retentions101611113re_tentions
retractions13910353retractions
retroflections1953873retroflections
revelations14410303revelations
selection11311273se_lection_

Search took 8 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 Filter1786911216330.390458182.1
2DLD Change Limit121633876.89017653.6
3Display Results87870.096906.3
 (SQL Overall)178691877.37624226.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.