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

59 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
revisionism1614481(None) 
revisionisms17143861revisionisms
revisionist14146521revisionist
divisionism1753202divisionism
revisionists15144802revisionists
revisions1238592revision_s_
deviationism1854023deviationism
divisionisms1862773divisionisms
divisionist1554633divisionist
precisionist1656483precisionist
previsioning1884083previsioning
previsions1547733prevision_s_
recisions1139913recision_s_
religionist1255663religionist
revision1138713revision___
revisionary1773523revisionary
creationism1576464cre_ationism
decisioning1543934decisioning
decisions1248384decision_s_
derisions1038844derision_s_
deviationisms1953884deviationisms
deviationist1656154deviationist
divisionists1653274divisionists
divisions1396284division_s_
elisions82210424_elision_s_
envisioning1552844envisioning
envisions1245614envision_s_
epigonism1445164_epi_gonism
evasions1136544_evasion_s_
fusionism1444604__fusionism
illusionism1353514illusionism
messianism1453724me_ssianism
precisionists1754634precisionists
precisions1449374precision_s_
prerevisionist19102524prerevisionist
prevision1448004prevision___
previsional1655324prevision_al
previsionary2083304previsionary
previsioned1744264prevision_ed
provisioning1883594provisioning
provisions1547214provision_s_
recidivism1852124recidi_vism
recision10310274recision___
redivisions1553804redivision_s_
reductionism1754324reductionism
religionists1354394religionists
religions1086604religion_s_
remissions1246614remission_s_
reunionist1056174re_unionist
reversions1347574reversion_s_
revising122714404revisi_n__g
revisiting1446954revisi_ting
revisits1137424revisi__ts_
revisors11379064revis_o_rs_
revivalism1844124revi_valism
revulsions1344264revulsion_s_
secessionism1653444secessionism
visioning1347064__visioning
visions10311024__vision_s_

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.423422437.4
2DLD Change Limit148819598.25018038.7
3Display Results59590.0301966.7
 (SQL Overall)178691598.70320532.1
 
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.