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

109 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
eversion113871(None) 
aversion1147311aversion
emersion1047731emersion
eversions1238361eversions
reversion1248091reversion
version10310921_version
aversions1247052aversions
diversion1346452diversion
emersions1147282emersions
evasion1036752ev_asion
evection131910832evection
evulsion1155062evulsion
exertion15310082exertion
inversion1247212inversion
obversion1444732obversion
oversoon1138302oversoon
perversion1545852perversion
reversions1347572reversions
versions11310352_versions
aspersion1146163aspersion
aversive1447443aversive
avulsion1153863avulsion
cession939813_cession
coercion1246573coercion
conversion1548423conversion
derision939073_derision
desertion10410203desertion
diversions1446533diversions
eclosion1046893eclosion
effusion1444603effusion
egestion946863egestion
egression1046193egression
ejection172510043ejection
election102015353election
elision72311103e_lision
elusion72310953e_lusion
emission1047673emission
emulsion1045923emulsion
envision1145953envision
erasion7311963e_rasion
erection102115513erection
erepsin937383erepsi_n
erosion7311113e_rosion
etesian757853ete_sian
evasions1136543ev_asions
evections142510693evections
evensong1242653evens_ong
eversible1475443eversible
everting122213133everting
evertor1038723ever_tor
everyman1643513everyman
everymen1644423everymen
everyone1444763ever_yone
eviction13228683eviction
evulsions1254573evulsions
excision1746273excision
excursion1844613excursion
exertions1639763exertions
exsertion1646853exsertion
extension1646293extension
extrusion1645253extrusion
fermion1236763_fermion
immersion1344283immersion
inversions1347003inversions
lesion64715063_le_sion
obversions1544513obversions
overseen112612173overseen
oversewn14266933oversewn
overshoe1438563overshoe
overshot1449433overshot
oversick1736983oversick
overside122013933overside
oversize201812513oversize
overslow1435693overslow
overspin1338203overspin
pension9412203_pension
pereion9312053_pereion
person83517873_pers_on
perversions1645413perversions
recension1148863recension
recession1149103recession
recursion1146153recursion
retorsion946503retorsion
reversing132611483reversing
reversional1454033reversional
reversioner1453133reversioner
reverso10367693revers_o_
reversos11266713revers_os
revision1138713rev_ision
revulsion1244353revulsion
secession1146703secession
session739763_session
subversion1544503subversion
tension7311803_tension
ternion739493_ternion
thermion1345933thermion
torsion7310803_torsion
venison1036443_venison
verdin103113023_verdi_n
vermian12329713_vermian
vermin113414523_vermi_n
versify1636333_versify
versine102515173_versine
versing112314193_versing
versional1245863_versional
verso85314633_vers_o_
versos93812803_vers_os
virion9310683_vir_ion
vision9311313_v_ision

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.406440125.6
2DLD Change Limit1461621096.78021557.8
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.23224708.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.