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

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

82 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
reflectional175399(None) 
inflectional1754382inflectional
reflection15168992reflection__
reflections16178552reflection_s
affectional1953893_affectional
deflection16147733deflection__
deflections17187323deflection_s
recreational1455173recreational
redactional1454353re_dactional
reductional1454593re_ductional
reelection12198633reelection__
reelections13167943reelection_s
refection141512283ref_ection__
refections151811643ref_ection_s
reflecting1638823reflecti_n_g
relational1047713re_l_ational
bifunctional19132864bifunctional
bisectional1554644_bisectional
connectional1646724connectional
convectional1947044convectional
correctional1675324correctional
deceptional1654774de_ceptional
declensional1551914declensional
defection151610644def_ection__
defections161510204def_ection_s
definitional1653034definitional
deflecting1736504deflecti_n_g
difunctional18123374difunctional
directional1445444_directional
election102015354_e_lection__
elections112414974_e_lection_s
electoral1156724_e_lect_oral
exceptional2254444_exceptional
factional1478764__f_actional
fictional1477804__f_ictional
flection13239564__flection__
flections14239214__flection_s
flexional1942474__fle_xional
fractional1547134__fractional
frictional1546254__frictional
functional15116674__functional
inflection1547634inflection__
inflectionally2262954inflectionally
inflections1646994inflection_s
perceptional1854904perceptional
preelection15136484preelection__
prelection141511294pre_lection__
prelections151210474pre_lection_s
projectional2355424projectional
rarefactional18101764raref_actional
recessional1354984re_cessional
reelecting1338784reelecti_n_g
refecting152413354ref_ecti_n_g
reflation12412334refl_ation__
reflationary1872614refl_ationary
reflations13311234refl_ation_s
reflectance1852864reflect_ance
reflective1857124reflecti__ve
reflectively2354814reflectively
reflectivity2353814reflectivity
reflector1445734reflect_o__r
reflectors1545504reflect_o_rs
reflexion1943614refle_xion__
reflexions2043304refle_xion_s
reformational18113424reformational
refraction15137904refraction__
refractions16127724refraction_s
rejection181710254re_jection__
rejections191510104re_jection_s
reliction11310694re_liction__
relictions12310024re_liction_s
repetitional1453724repetitional
repletion1147694reple_tion__
repletions1247474reple_tion_s
reputational1474584reputational
resection111613274re_section__
resections121513034re_section_s
resurrectional1661754resurrectional
reversional1454034re_versional
sectional1149424___sectional
selection11311274se_lection__
selections12310874se_lection_s

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 Filter1786911247900.406440125.6
2DLD Change Limit124790827.45316743.6
3Display Results82820.0461782.6
 (SQL Overall)178691827.90522604.8
 
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.