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

174 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
nidation941058(None) 
nidations1039211nidations
animation11313682animation
citation10314362citation
dilation92215462dilation
fixation1837072fixation
himation1339752himation
ideation9310492_ideation
iodation9310382iodation
libation102411362libation
ligation92313092ligation
natation81513932natation
nation64322802n__ation
negation92913022negation
nictation1189272nictation
nidating1039782nidating
nitration9313442nitration
notation81414602notation
novation111710012novation
nutation81513102nutation
oxidation1746322oxidation
sedation9312452sedation
sudation9310802sudation
ablation10312433ablation
adaption1145643_adaption
addition1096893addition
adnation9310783adnation
aeration8319933aeration
agitation10311223agitation
agnation9311723agnation
alation72920553_alation
animations12312193animations
audition979173audition
aviation11312743aviation
cation83925503__cation
caudation1269993caudation
ciliation111112493ciliation
citations11312503citations
cnidarian1244483cnidarian
conation101420883conation
creation102816513creation
delation92318083delation
denudation1247303denudation
diatron839283di_atron
dictation12810563dictation
diction102313053di_ction
dilations102614453dilations
dilution9239143dilution
donation91513783donation
dotation91412733dotation
duration9312693duration
edition8310853_edition
elation73620453_elation
enation73419233_enation
epilation11312963epilation
equation17310483equation
exudation1787693exudation
fetation11613143fetation
fiction122010733fi_ction
filiation121110243filiation
fixations1936353fixations
gelation93014433gelation
gigaton946343gigat_on
gradation11107713gradation
gyration1237763gyration
halation11313853halation
himations1438803himations
hydration1646073hydration
ideations1039903_ideations
illation8311943illation
imitation11510853imitation
inaction1039623inaction
incaution1146583incaution
incitation12312223incitation
indagation1246153indagation
indamin1048043indami_n
indention1049513indention
indexation1846343indexation
indication13312033indication
indiction1239813indiction
induction1248983induction
induration11410613induration
infixation2047533infixation
inflation12311093inflation
initiation10412103initiation
intimation12413043intimation
inundation11116173inundation
invasion11115473invasion
invitation13410023invitation
iodations1039113iodations
ionization19411273ionization
isatin6412213_isati_n
kation104315683__kation
laudation1088133laudation
lavation1139973lavation
laxation1538423laxation
legation92412933legation
libations112510443libations
libration111510163libration
ligations102111993ligations
lineation9310763lineation
liquation1846553liquation
lobation102110553lobation
location102113913location
lunation8311923lunation
luxation1538233luxation
mediation12312293mediation
migration12179703migration
mutation101412883mutation
narration9310063narration
nasion63914083n__asion
natations91412493natations
nations74720563n__ations
natron64116023n__atron
navigation1446003navigation
negations102811963negations
negaton8299143negat_on
negatron9335993negatron
nervation12610243nervation
niacin8310223ni_aci_n
nicotin948383nicoti_n
nictations1278313nictations
nidate7313783nidat__e
nidated939863nidat_ed
nidates8311893nidat_es
niton55418283ni__t_on
nitrations10312033nitrations
nodulation11127993nodulation
nomination12712103nomination
nonaction1149443nonaction
notations91512973notations
notion64516583n__otion
novations12139003novations
nunnation9126563nunnation
nutations91411763nutations
oblation1039863oblation
oration71617713_oration
ovation101510023_ovation
oxidations1845443oxidations
pinnation1138013pinnation
plication13311683plication
potation101716783potation
predation12313463predation
privation14311173privation
pupation1269503pupation
radiation10313403radiation
ration64226013__ration
redaction1259663redaction
relation82619773relation
rogation91612053rogation
rotation81615453rotation
ruination9311273ruination
sanitation10412043sanitation
sedations10311253sedations
sedition939333sedition
siltation939213siltation
sinuation9310413sinuation
situation949423situation
solation8916153solation
sonication12411183sonication
station72717243_station
sudations1039903sudations
taxation1537993taxation
titration9310543titration
urination9312173urination
vacation131911893vacation
validation1448413validation
venation11513503venation
vexation1838783vexation
vibration14138203vibration
violation1238443violation
vitiation1239563vitiation
vocation132311983vocation
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.420425454.8
2DLD Change Limit1461621747.23620199.3
3Display Results1741740.0762289.5
 (SQL Overall)1786911747.73223110.6
 
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.