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

92 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
revocation1541081(None) 
evocation142010291_evocation
relocation12312111relocation
revocations16410311revocations
advocation1645742advocation
avocation14168992_avocation
evocations15259872_evocations
invocation1547542invocation
provocation1847352provocation
relocations13311142relocations
renovation1358782renovation
revelation13410922revelation
revolution13117562revolution
vocation132311982__vocation
advocations1755413advocations
allocation1248573allocation
avocations15168683_avocations
bilocation1446123bilocation
convocation1847883convocation
decoction1447523decoc_tion
decoration13314423decoration
dedication14311963dedication
defecation1679803defecation
denotation11311083denotation
derogation12410393derogation
desolation11311403desolation
detonation11310943detonation
deviation13312393dev_iation
devolution1486283devolution
devotion1256763devo__tion
education12310203_education
elocution1145673_elocution
evacuation1547163_evacuation
evection131910833_evec_tion
eviction13228683_evic_tion
evocative1746293_evocative
evocator1346573_evocat_or
evolution12117093_evolution
invocations1647063invocations
levigation1447023levigation
levitation1349443levitation
location102113913__location
medication15411173medication
peroration12316003peroration
predication16412433predication
prevocational2054013prevocational
provocations1956873provocations
reaction10612603re_ac_tion
reallocation1454493reallocation
recaution1148093re__caution
recitation12315943recitation
recordation1449263recordation
recreation12413613recreation
redaction1259663redac_tion
reduction1259903reduc_tion
reeducation1445933reeducation
refection141512283refec_tion
reflation12412333re_flation
reformation1648413reformation
refraction15137903refraction
refutation1349913refutation
regulation11312053regulation
reification16412903reification
rejection181710253rejec_tion
relation82619773re__lation
relaxation1746453relaxation
relegation11610023relegation
reliction11310693relic_tion
relocating13310873relocating
reluctation1347963reluctation
remotion10410233remo__tion
renovations1448423renovations
reparation12612723reparation
replication15712013replication
reposition121010143reposition
reprobation1548503reprobation
reputation12411883reputation
resection111613273resec_tion
resolution1097733resolution
resorption1247253resorption
restation9316913re_station
restoration11412093restoration
retortion949673reto_rtion
retraction121310533retraction
retroaction1347363retroaction
revaluation1458143revaluation
revelations14410303revelations
revolutions1497633revolutions
rogation91612053r__ogation
rotation81615453r__otation
vacation131911893__vacation
vocations141911423__vocations

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 Filter1786911406030.423422437.4
2DLD Change Limit140603925.71624598.1
3Display Results92920.0501840.0
 (SQL Overall)178691926.18928872.4
 
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.