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

172 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
vexation183878(None) 
venation11513501venation
vexations1937751vexations
aeration8319932aeration
delation92318082delation
elation73620452_elation
enation73419232_enation
exaction1738952_exaction
fetation11613142fetation
fixation1837072fixation
gelation93014432gelation
laxation1538422laxation
legation92412932legation
luxation1538232luxation
negation92913022negation
relation82619772relation
sedation9312452sedation
taxation1537992taxation
vacation131911892vacation
venations12311722venations
vernation12311082vernation
vexatious1944102vexatious
vocation132311982vocation
ablation10312433ablation
adnation9310783adnation
aerations9317903aerations
agnation9311723agnation
alation72920553_alation
annexation1744953annexation
aviation11312743aviation
avocation14168993avocation
betatron1045233betatron
bevatron1343883bevatron
cation83925503__cation
ceratin93020163cerati_n
cessation1176853cessation
chelation1439973chelation
citation10314363citation
conation101420883conation
creation102816513creation
cremation13511643cremation
crenation11412923crenation
dealation10313003dealation
deflation13310653deflation
delations102616593delations
deletion92011973deletion
demotion1169073demotion
dentation10315243dentation
deviation13312393deviation
devotion1256763devotion
dilation92215463dilation
donation91513783donation
dotation91412733dotation
duration9312693duration
edition8310853_edition
elations83719123_elations
elevation1239233elevation
elution72913823_elution
emotion9711303_emotion
enations83316903_enations
equation17310483equation
erasion7311963_erasion
evasion1036753_evasion
evection131910833evection
eviction13228683eviction
evocation142010293evocation
exactions1838923_exactions
exciton1646083_exciton
exertion15310083_exertion
expiation18710423_expiation
exudation1787693_exudation
fellation1238843fellation
fetations12511383fetations
fixations1936353fixations
gelatin83514733gelati_n
gelations102513093gelations
gemmation1445963gemmation
gestation10310663gestation
gyration1237763gyration
halation11313853halation
hematin121516023hemati_n
hexagon1843823hexa_gon
himation1339753himation
ideation9310493ideation
illation8311943illation
indexation1846343indexation
iodation9310383iodation
iteration9515033iteration
kation104315683__kation
keratin113314153kerati_n
lavation1139973lavation
laxations1637623laxations
lection92614863le_ction
legations102711923legations
lenition8310083lenition
libation102411363libation
ligation92313093ligation
lobation102110553lobation
location102113913location
lunation8311923lunation
luxations1637273luxations
mediation12312293mediation
megaton10269853megat_on
mentation11313983mentation
mention9314373me_ntion
mutation101412883mutation
natation81513933natation
nation64322803__nation
negations102811963negations
negaton8299143negat_on
negatron9335993negatron
nervation12610243nervation
nidation9410583nidation
notation81414603notation
novation111710013novation
nutation81513103nutation
oblation1039863oblation
operation11314003operation
oration71617713_oration
ovation101510023_ovation
overaction1547993overaction
ovulation1238983ovulation
peltation11312963peltation
petition10711753petition
potation101716783potation
predation12313463predation
pupation1269503pupation
ration64226013__ration
reaction10612603reaction
recaution1148093recaution
redaction1259663redaction
reflation12412333reflation
relations92418333relations
relaxation1746453relaxation
remotion10410233remotion
restation9316913restation
revelation13410923revelation
rogation91612053rogation
rotation81615453rotation
section92515663se_ction
sedations10311253sedations
sedition939333sedition
sensation9510583sensation
seriation9318063seriation
serration9414073serration
sextain14257103sextai_n
sexton133610793sex_t_on
solation8916153solation
station72717243_station
sudation9310803sudation
taxations1636863taxations
tevatron1143973tevatron
vacations141910553vacations
vallation1239753vallation
valuation1249973valuation
variation12312393variation
vegetation1448213vegetation
venatic12311523venati_c
vendition1345693vendition
veneration13412343veneration
venetian1146073venetian
veratrin1147703veratrin
vernations13310333vernations
version10310923ve_rsion
vibration14138203vibration
violation1238443violation
vitiation1239563vitiation
vocations141911423vocations
volition1179173volition
volution1198603volution
zeatin15412823ze_ati_n
zonation171410723zonation

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.453394461.4
2DLD Change Limit1461621727.15620425.1
3Display Results1721720.0802150.0
 (SQL Overall)1786911727.68923239.8
 
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.