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

173 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
vexations193775(None) 
venations12311721venations
vexation1838781vexation_
vexatious1944101vexatious
aerations9317902aerations
delations102616592delations
elations83719122_elations
enations83316902_enations
exactions1838922_exactions
fetations12511382fetations
fixations1936352fixations
gelations102513092gelations
laxations1637622laxations
legations102711922legations
luxations1637272luxations
negations102811962negations
relations92418332relations
sedations10311252sedations
taxations1636862taxations
vacations141910552vacations
venation11513502venation_
vernations13310332vernations
vocations141911422vocations
ablations11311513ablations
adnations1039753adnations
aeration8319933aeration_
agnations10310033agnations
alations82518893_alations
annexations1844263annexations
aviations12311553aviations
avocations15168683avocations
betatrons1145083betatrons
bevatrons1443713bevatrons
cations94524143__cations
ceratins102818733cerati_ns
cessations1256473cessations
chelations1539073chelations
citations11312503citations
conations111318903conations
creations112614543creations
cremations14410713cremations
crenations12511693crenations
dealations11311373dealations
deflations1439713deflations
delation92318083delation_
deletions102610933deletions
demotions1258443demotions
dentations11413633dentations
deviations14311163deviations
devotions1356593devotions
dilations102614453dilations
donations101112353donations
dotations101411633dotations
durations10311463durations
editions9310403_editions
elation73620453_elation_
elevations1338633elevations
elutions82513053_elutions
emotions10610283_emotions
enation73419233_enation_
equations1839493equations
erasions8310983_erasions
evasions1136543_evasions
evections142510693evections
evictions14228623evictions
evocations15259873evocations
exaction1738953_exaction_
excitons1746043_excitons
exertions1639763_exertions
expiations1959663_expiations
exudations18107073_exudations
fellations1338063fellations
fetation11613143fetation_
fixation1837073fixation_
gelatins93414093gelati_ns
gelation93014433gelation_
gemmations1545003gemmations
gestations1139773gestations
gyrations1336923gyrations
halations12312393halations
hematins131714683hemati_ns
hexagons1943943hexa_gons
himations1438803himations
ideations1039903ideations
illations9311393illations
indexations1946023indexations
iodations1039113iodations
iterations10413823iterations
kations114013663__kations
keratins122313483kerati_ns
lavations1238973lavations
laxation1538423laxation_
lections102413843le_ctions
legation92412933legation_
lenitions939473lenitions
libations112510443libations
ligations102111993ligations
lobations11219613lobations
locations112512743locations
lunations9310723lunations
luxation1538233luxation_
mediations13310983mediations
megatons11279703megat_ons
mentations12312583mentations
mentions10312893me_ntions
mutations111211453mutations
natations91412493natations
nations74720563__nations
negation92913023negation_
negatons9299273negat_ons
negatrons10275843negatrons
nervations1359483nervations
nidations1039213nidations
notations91512973notations
novations12139003novations
nutations91411763nutations
oblations1139373oblations
operations12312953operations
orations81515803_orations
ovations11149263_ovations
overactions1648213overactions
ovulations1337973ovulations
peltations12311553peltations
petitions11511083petitions
potations111615073potations
predations13812153predations
pupations1338123pupations
rations74123433__rations
reactions11711713reactions
recautions1247813recautions
redactions1359133redactions
reflations13311233reflations
relation82619773relation_
relaxations1845643relaxations
remotions1149703remotions
restations10315843restations
revelations14410303revelations
rogations101510823rogations
rotations91613843rotations
sections102714703se_ctions
sedation9312453sedation_
seditions1039013seditions
sensations1059853sensations
seriations10316683seriations
serrations10313093serrations
sextains15246813sextai_ns
sextons143710413sex_t_ons
solations9814623solations
stations82415223_stations
sudations1039903sudations
taxation1537993taxation_
tevatrons1244003tevatrons
vacation131911893vacation_
vallations1339083vallations
valuations1348783valuations
variations13310773variations
vegetations1547323vegetations
venditions1445523venditions
venerations14411313venerations
venetians1244673venetians
veracious1447123veracious
veratrins1247753veratrins
vernation12311083vernation_
versions11310353ve_rsions
vexatiously2454363vexatiously
vibrations15157373vibrations
violations1337963violations
vitiations1338743vitiations
vocation132311983vocation_
volitions1288663volitions
volutions12108393volutions
zeatins16311733ze_ati_ns
zonations18139313zonations

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411736.50022867.8
3Display Results1731730.0961802.1
 (SQL Overall)1786911737.01625469.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.