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

90 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
reversional145403(None) 
recessional1354982recessional
reversion1248092reversion__
reversionary1852062reversionary
reversioner1453132reversioner
reversions1347572reversion_s
versional1245862__versional
conversional1755143conversional
evasional1244293_ev_asional
eversion1138713_eversion__
eversions1238363_eversion_s
precessional1655123precessional
previsional1655323prev_isional
recessionals1453613recessionals
reversal1145843revers___al
reversing132611483reversi_n_g
reversioners1552233reversioners
accessional15103604accessional
adhesional1472644adhe_sional
ascensional1362774ascensional
aversion1147314_aversion__
aversions1247054_aversion_s
deceptional1654774deceptional
decisional1344834de_cisional
declensional1551914declensional
delusional1153304de_lusional
devotional1444674dev_otional
dimensional1453044dimensional
diversion1346454diversion__
diversionary1962034diversionary
diversions1446534diversion_s
divisional1453954div_isional
emersion1047734_emersion__
emersions1147284_emersion_s
erosional946624_e_rosional
excisional1953844_excisional
extensional1854184extensional
generational1354824generational
impersonal1454744impers_onal
insertional1147464insertional
intensional11146564intensional
inversion1247214inversion__
inversions1347004inversion_s
obsessional1353344obsessional
obversion1444734obversion__
obversions1544514obversion_s
personal102311574__pers_onal
perversion1545854perversion__
perversions1645414perversion_s
preterminal1554584pretermi_nal
processional1665394processional
professional1754964professional
provisional1655464prov_isional
recension1148864recension__
recensions1248484recension_s
recession1149104recession__
recessionary1753064recessionary
recessions1248934recession_s
recreational1455174recreational
recursion1146154recursion__
recursions1245404recursion_s
redactional1454354redactional
reductional1454594reductional
reflectional1753994reflectional
regional9438784r__e_gional
relational1047714re_lational
repetitional1453724repetitional
retorsion946504retorsion__
retorsions1045714retorsion_s
reverbing15248594reverbi_n_g
reverential1484464reverential
revering122918074rever_i_n_g
reversals1245204revers___als
reversible1574904reversi_ble
reversibles1682854reversibles
reversibly1873834reversi_bly
reverso10367694revers_o___
reversos11266714revers_o__s
reverting132315134reverti_n_g
revision1138714rev_ision__
revisionary1773524rev_isionary
revisions1238594rev_ision_s
revulsion1244354revulsion__
revulsions1344264revulsion_s
sessional946114__sessional
tensional946214__tensional
torsional945034__torsional
version10310924__version__
versions11310354__version_s
visional1146664__v_isional

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 Filter1786911488190.453394461.4
2DLD Change Limit148819908.39317731.3
3Display Results90900.0461956.5
 (SQL Overall)178691908.89220095.7
 
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.