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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

125 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
revisions123859(None) 
previsions1547731previsions
recisions1139911recisions
revision1138711revision_
decisions1248382decisions
derisions1038842derisions
divisions1396282divisions
elisions82210422_elisions
envisions1245612envisions
evasions1136542_evasions
precisions1449372precisions
prevision1448002prevision_
provisions1547212provisions
recision10310272recision_
redivisions1553802redivisions
religions1086602religions
remissions1246612remissions
reversions1347572reversions
revising122714402revisi_ng
revisionism16144812revisionism
revisionist14146522revisionist
revisits1137422revisi_ts
revisors11379062revis_ors
revulsions1344262revulsions
visions10311022__visions
aversions1247053aversions
benisons1037043benis_ons
cessions1039853ce_ssions
decision1148523decision_
delusions1037053delusions
demissions1345663demissions
derision939073derision_
deviations14311163deviations
devising133111523devisi_ng
devisors12347253devis_ors
devotions1356593devotions
division1266683division_
editions9310403_editions
elision72311103_elision_
elusions82610083_elusions
emissions1146923_emissions
envision1145953envision_
erasions8310983_erasions
erosions8310343_erosions
evasion1036753_evasion_
eversions1238363_eversions
evictions14228623_evictions
evulsions1254573_evulsions
excisions1846383excisions
incisions1147353incisions
invasions12115413invasions
lenitions939473lenitions
lesions73813873le__sions
lewissons1241743lewissons
pavilions1444793pavilions
pensions10311693pe_nsions
pervasions1545663pervasions
petitions11511083petitions
precisians1446413precisians
precision13410053precision_
prefixions2243873prefixions
prelusions1256373prelusions
prevising15510873previsi_ng
previsional1655323previsional
previsioned1744263previsioned
previsits1446793previsi_ts
previsors14126483previs_ors
provision1447633provision_
raisins72715343r_aisi_ns
reactions11711713reactions
reasons72514943re_as_ons
reassigns1074353reassigns
recensions1248483recensions
recessions1248933recessions
reclusions1246243reclusions
recursions1245403recursions
redesigns1144073redesigns
redivision1453873redivision_
reeditions1147653reeditions
reemissions1344153reemissions
refashions1643063refashions
regions83613473re__gions
reinvasions1442793reinvasions
relations92418333relations
relictions12310023relictions
religion996743religion_
religious1076033religious
remising112516453remisi_ng
remission1147333remission_
remotions1149703remotions
renditions1149183renditions
reprovisions1753773reprovisions
repulsions1244793repulsions
rerising93017783rerisi_ng
rescissions1344593rescissions
resigns83910963re__signs
resilins83013373resili_ns
resins64528773re__si_ns
resistors947993resistors
retorsions1045713retorsions
reunions837273re_unions
reversion1248093reversion_
reviling122917213revili_ng
revisals1136813revis_als
revisers113511933revis_ers
revises104220533revis__es
revisionary1773523revisionary
revisionisms17143863revisionisms
revisionists15144803revisionists
revisit10311373revisi__t
revisited1346573revisited
revisiting1446953revisiting
revisor10388733revis_o_r
revisory14306013revis_ory
reviving152910503revivi_ng
revulsion1244353revulsion_
seditions1039013seditions
seisins73614393se_isi_ns
sessions839723se_ssions
televisions1452343televisions
tensions8310223te_nsions
venisons1136133venis_ons
versions11310353ve_rsions
virions1039873__virions
vision9311313__vision_

Search took 7 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 Filter1786911486410.1701051123.5
2DLD Change Limit1486411256.54622707.1
3Display Results1251250.0631984.1
 (SQL Overall)1786911256.77926359.5
 
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.