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

171 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
novation11171001(None) 
notation81414601notation
novations12139001novations
ovation101510021_ovation
conation101420882conation
donation91513782donation
dotation91412732dotation
innovation1345642innovation
iodation9310382iodation
lavation1139972lavation
lobation102110552lobation
location102113912location
natation81513932natation
nation64322802n__ation
negation92913022negation
nervation12610242nervation
nidation9410582nidation
nonaction1149442nonaction
notations91512972notations
notion64516582no__tion
nutation81513102nutation
oration71617712_oration
ovations11149262_ovations
potation101716782potation
renovation1358782renovation
rogation91612052rogation
rotation81615452rotation
solation8916152solation
solvation1237772solvation
vocation132311982vocation
zonation171410722zonation
ablation10312433ablation
adnation9310783adnation
adoration10311313adoration
aeration8319933aeration
agnation9311723agnation
alation72920553_alation
animation11313683animation
annotation1047753annotation
aviation11312743aviation
avocation14168993avocation
bevatron1343883bevatron
bloviation1544003bloviation
cation83925503__cation
citation10314363citation
clavation1447003clavation
coaction12310773coaction
cognation12310753cognation
coition9314313co_ition
collation11313993collation
conations111318903conations
connation11314263connation
cooption1288343cooption
copatron1246753copatron
creation102816513creation
delation92318083delation
denotation11311083denotation
deviation13312393deviation
devotion1256763devotion
dilation92215463dilation
donations101112353donations
dotations101411633dotations
duration9312693duration
elation73620453_elation
elevation1239233elevation
enation73419233_enation
enervation1369473enervation
equation17310483equation
evasion1036753_evasion
evocation142010293evocation
fetation11613143fetation
fixation1837073fixation
flotation1267813flotation
foliation121110793foliation
formation1439423formation
gelation93014433gelation
gyration1237763gyration
halation11313853halation
himation1339753himation
ideation9310493ideation
illation8311943illation
inflation12311093inflation
innovations1445263innovations
insolation10410213insolation
intonation10410263intonation
invasion11115473invasion
invocation1547543invocation
iodations1039113iodations
isolation9311643isolation
kation104315683__kation
lavations1238973lavations
laxation1538423laxation
legation92412933legation
libation102411363libation
ligation92313093ligation
lobations11219613lobations
locations112512743locations
locution10227663locution
lotion65716523lo__tion
lunation8311923lunation
luxation1538233luxation
monition10311723monition
motion85217553mo__tion
motivation1548083motivation
mutation101412883mutation
narration9310063narration
nasion63914083n__asion
natations91412493natations
nations74720563n__ations
natron64116023n__atron
navigation1446003navigation
negations102811963negations
negaton8299143negat_on
negatron9335993negatron
nervations1359483nervations
nictation1189273nictation
nidations1039213nidations
nitration9313443nitration
nodulation11127993nodulation
nomination12712103nomination
nonactions1248373nonactions
nonagon847313nona_gon
nonunion845583nonunion
notating92513343notating
notational1048123notational
notions74014483no__tions
novalike1536223novalike
nunnation9126563nunnation
nutations91411763nutations
oblation1039863oblation
obviation1446093obviation
option83612713_o_ption
orations81515803_orations
ovarian1037643_ovarian
ovational1246853_ovational
ovulation1238983_ovulation
ozonation1845673ozonation
phonation1439393phonation
portion9615493po_rtion
position10912193position
potations111615073potations
potion84519573po__tion
privation14311173privation
probation13412183probation
pronation11415703pronation
proration11415983proration
pupation1269503pupation
quotation18146973quotation
ration64226013__ration
relation82619773relation
renovations1448423renovations
rogations101510823rogations
rotations91613843rotations
salvation1239293salvation
sedation9312453sedation
solations9814623solations
solution889593solution
solvations1336833solvations
sorption1037513sorption
station72717243_station
sudation9310803sudation
taxation1537993taxation
tevatron1143973tevatron
vacation131911893vacation
venation11513503venation
vexation1838783vexation
violation1238443violation
vocations141911423vocations
volition1179173volition
volution1198603volution
zonations18139313zonations

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.1561145455.1
2DLD Change Limit1461621717.90618487.5
3Display Results1711710.0762250.0
 (SQL Overall)1786911718.13821957.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.