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

129 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
revision113871(None) 
prevision1448001prevision
recision10310271recision
revisions1238591revisions
decision1148522decision
derision939072derision
division1266682division
elision72311102_elision
envision1145952envision
evasion1036752_evasion
precision13410052precision
previsions1547732previsions
provision1447632provision
recisions1139912recisions
redivision1453872redivision
religion996742religion
remission1147332remission
reversion1248092reversion
revising122714402revising
revisit10311372revisi_t
revisits1137422revisits
revisor10388732revis_or
revulsion1244352revulsion
vision9311312__vision
aversion1147313aversion
benison937123benis_on
cession939813ce_ssion
decisions1248383decisions
delusion937433delusion
demission1246033demission
derisions1038843derisions
deviation13312393deviation
devising133111523devising
devisor11357043devis_or
devotion1256763devotion
divisions1396283divisions
edition8310853_edition
elisions82210423_elisions
elusion72310953_elusion
emission1047673_emission
envisions1245613envisions
erasion7311963_erasion
erosion7311123_erosion
evasions1136543_evasions
eversion1138713_eversion
eviction13228683_eviction
evulsion1155063_evulsion
excision1746273excision
incision1047603incision
invasion11115473invasion
lenition8310083lenition
lesion64715063le__sion
lewisson1142023lewisson
pavilion1344903pavilion
pension9412203pe_nsion
pervasion1446073pervasion
petition10711753petition
precisian1347813precisian
precisions1449373precisions
prefixion2144113prefixion
prelusion1156603prelusion
prevising15510873prevising
previsional1655323previsional
previsioned1744263previsioned
previsit13410073previsi_t
previsits1446793previsits
previsor13116303previs_or
provisions1547213provisions
raisin62716923r_aisi_n
reaction10612603reaction
reason62616333re_as_on
reassign955423reassign
recension1148863recension
recession1149103recession
reclusion1146503reclusion
recursion1146153recursion
redesign1045073redesign
redivisions1553803redivisions
reedition1047833reedition
reemission1244333reemission
refashion1543353refashion
region74614903re__gion
reinvasion1343013reinvasion
relation82619773relation
reliction11310693reliction
religions1086603religions
remising112516453remising
remissions1246613remissions
remotion10410233remotion
rendition1058933rendition
reprovision1653713reprovision
repulsion1145193repulsion
rerisen73613643reris_en
rerising93017783rerising
rescission1244863rescission
resign74212583re__sign
resilin72913973resili_n
resin54131053re__si_n
resistor847673resistor
retorsion946503retorsion
reunion737673re_union
reversions1347573reversions
reviling122917213reviling
revisal1038263revis_al
revisals1136813revisals
revise94019743revis__e
revised113815483revis_ed
reviser104114663revis_er
revisers113511933revisers
revises104220533revis_es
revisionary1773523revisionary
revisionism16144823revisionism
revisionist14146533revisionist
revisited1346573revisited
revisiting1446953revisiting
revisors11379063revisors
revisory14306013revisory
revivify2042923revivify
reviving152910503reviving
revulsions1344263revulsions
sedition939333sedition
seisin63715123se_isi_n
session739763se_ssion
television1352463television
tension7311803te_nsion
venison1036443venis_on
version10310923ve_rsion
virion9310683__virion
visions10311023__visions

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621297.18620339.8
3Display Results1291290.0632047.6
 (SQL Overall)1786911297.68523251.9
 
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.