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

145 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
taxation153799(None) 
laxation1538421laxation
taxations1636861taxations
alation72920552_alation
fixation1837072fixation
halation11313852halation
lavation1139972lavation
laxations1637622laxations
luxation1538232luxation
natation81513932natation
taction93213022ta_ction
tarnation9310092tarnation
vacation131911892vacation
vexation1838782vexation
ablation10312433ablation
action84719683_a_ction
adaption1145643_adaption
adnation9310783adnation
aeration8319933aeration
agnation9311723agnation
alations82518893_alations
amotion9710473_amotion
auction93412933_auction
aviation11312743aviation
axion1211316913_ax__ion
bastion9312473ba_stion
caption113513693ca_ption
carnation11312943carnation
caseation1199513caseation
cassation1197913cassation
cation83925503__cation
caudation1269993caudation
causation1199523causation
caution93013523ca_ution
citation10314363citation
clavation1447003clavation
conation101420883conation
creation102816513creation
damnation1238403damnation
darnation1039823darnation
dealation10313003dealation
delation92318083delation
dilation92215463dilation
donation91513783donation
dotation91412733dotation
duration9312693duration
elation73620453_elation
emanation11910783emanation
enation73419233_enation
equation17310483equation
exaction1738953exaction
faction122613333fa_ction
fetation11613143fetation
fixations1936353fixations
gelation93014433gelation
gradation11107713gradation
gyration1237763gyration
halations12312393halations
himation1339753himation
ideation9310493ideation
illation8311943illation
iodation9310383iodation
iteration9515033iteration
jactation1838143jactation
kation104315683__kation
lactation11310813lactation
lallation939493lallation
laudation1088133laudation
lavations1238973lavations
laxative1845093laxative
legation92412933legation
libation102411363libation
ligation92313093ligation
lobation102110553lobation
location102113913location
lunation8311923lunation
luxations1637273luxations
malathion1444513malathion
marathon1346813marathon
mutation101412883mutation
narration9310063narration
natations91412493natations
nation64322803__nation
negation92913023negation
nidation9410583nidation
notation81414603notation
novation111710013novation
nutation81513103nutation
oblation1039863oblation
oration71617713_oration
ovation101510023_ovation
paction112713963pa_ction
palmation13310223palmation
palpation1339073palpation
parathion1446173parathion
placation1339773placation
planation11310123planation
potation101716783potation
pupation1269503pupation
radiation10313393radiation
ration64226013__ration
relation82619773relation
relaxation1746453relaxation
rogation91612053rogation
rotation81615453rotation
sabaton937713sabat_on
sacaton938993sacat_on
saltation9312003saltation
salvation1239293salvation
sanction1049533sanction
satiation9313433satiation
saxatile1544953saxatile
scalation11311073scalation
sedation9312453sedation
solation8916153solation
stagnation1145543stagnation
starvation1345493starvation
station72717243_station
striation9313483striation
sudation9310803sudation
tabulation1247813tabulation
tactions102912423ta_ctions
talapoin1045013talapoin
talion6317713t__alion
talkathon1692423talkathon
tamarin9311913tamari_n
tampion11298663ta_mpion
tarnations1038903tarnations
taxitic1637093taxiti_c
taxon124414663tax___on
tevatron1143973tevatron
titration9310543titration
trabeation1245883trabeation
traction10412683traction
tradition1047593tradition
tuition738823t_uition
vacations141910553vacations
vallation1239743vallation
valuation1249973valuation
variation12312393variation
venation11513503venation
vexations1937753vexations
vocation132311983vocation
zacaton1845633zacat_on
zonation171410723zonation

Search took 9 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.423422437.4
2DLD Change Limit1461621458.03018202.0
3Display Results1451450.0632301.6
 (SQL Overall)1786911458.51620983.0
 
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.